Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Restoring a dabase with a new name

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-12-03 : 08:37:24
Margaret writes "I am trying to restore a database called Test and I would like to restore it to a new database called NewTest. It restores fine but the logical name is still called Test. I get an error when I try to change the name during a restore in the gui. How can I restore the test database to the new name "NewTest" with a logical name of NewTest?"

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2001-12-03 : 12:27:49
If you're using Enterprise Manager, try restoring from device and on the Options Tab you can change file names/locations.

-------------------
It's a SQL thing...
Go to Top of Page
   

- Advertisement -