SQL Server Performance Forum – Threads Archive

restore database with other name

Hi,
I have a database on one server (db_prod) and I have a copy of this database on a standby server (db_prod) but I don#%92t have a test server.
What I want to do is to use the stand by server for tests and to create a new database db_test.
Haw can I restore the backup for db_prod on my db_test? Tanks in advance

Yes, you can use Enterprise Manager, databases, all task, restore and set the name you want.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Hi, All work fine with this:
BACKUP DATABASE Northwind
TO DISK = ‘d:Northwind.bak’
–RESTORE FILELISTONLY
–FROM DISK = ‘d:Northwind.bak’
RESTORE DATABASE TestDB
FROM DISK = ‘d:Northwind.bak’
WITH MOVE ‘Northwind’ TO ‘d: estdb.mdf’,
MOVE ‘Northwind_log’ TO ‘d: estdb.ldf’
GO Many thanks

]]>