How to change the name of sql server2000 restore data backups

You can run the following script to change the file name and path: RESTORE FILELISTONLY

FROM DISK = 'C:BankDB_FilesFull_BackupBankDBbackup.bak'

GO

RESTORE DATABASE [BankArchive]

FROM DISK = N'C:BankDB_FilesFull_BackupBankDBbackup.bak'

WITH FILE = 1,

MOVE N'BankDB' TO N'C. BankArchive_FilesBankArchive.mdf',

MOVE N'BankDB2' TO N'C:BankArchive_FilesBankArchive2.ndf',

MOVE N'BankDB3' TO N'C. BankArchive_FilesBankArchive3.ndf',

MOVE N'BankDB_Log' TO N'C:BankArchive_FilesBankArchive_Log.ldf',

NOUNLOAD, REPLACE.

MOVE N'BankDB' TO N'C:BankArchive_FilesBankArchive.mdf',

MOVE N'BankDB2' TO N'C:BankArchive_FilesBankArchive2.ndf',

MOVE N'BankDB3' TO N'C:BankArchive_FilesBankArchive3.ndf',

MOVE N'BankDB_Log' TO N'C:BankArchive_FilesBankArchive_Log.ldf',

NOUNLOAD, REPLACE, STATS = 10

GO

Only the following will work in Management Studio:

Restore:

1. Right click on databases, choose 'restore database'.

2. In the Restore Database window, write the name of your destination database (BankArcive), and then specify the location of backup sets to restore (database or device).

3. Go to Options and change the name and/or location of the physical files (.mdf, .ldf) and click 4. OK.

Rename of existing database:

EXEC sp_helpdb 'BankDB'

GO

ALTER DATABASE BankDB

MODIFY FILE

(NAME = BankDB, NEWNAME='BankArchive')

GO

The name and/or location of the physical files (.mdf, .ldf) and click 4. p>ALTER DATABASE BankDB

MODIFY FILE

(NAME = BankDB2, NEWNAME='BankArchive2')

GO

ALTER DATABASE BankDB

MODIFY FILE

(NAME = BankDB3, NEWNAME='BankArchive3')

GO

ALTER DATABASE BankDB

MODIFY FILE

(NAME = BankDB_Log, NEWNAME = 'BankArchive_Log')

GO

Detailed information reference:

/library/ms190447(v=sql.105).aspx