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.
| Author |
Topic |
|
gamaz
Posting Yak Master
104 Posts |
 Posted - 2005-12-23 : 13:40:39
|
| Hi, What I have done is made a backup of pubs database. I named this file as pubs_bak. Now I want to restore this file as a new database i.e. pubstest database. While trying to restore this file with a new database name, it does not allow me to do so. I have very little idea of sql administration. Is this possible to do? If it is, then what is the best way to restore the backed up file with a new database name? Thanks in advance. |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2005-12-23 : 13:44:23
|
| in the restore, you will have to rename the files. It should be among the options. |
 |
|
|
TimS
Posting Yak Master
198 Posts |
Posted - 2005-12-23 : 13:58:02
|
| I think you need to use WITH MOVE option of RESTORE |
|
|
|
|
|
|
Restoring a backup file with a new database name