January 8, 2009 at 10:25 pm
can anyone guide me how can i restore database backup of name "cbs_test" to new database "rmsdb" i have created backup of old database and when i try to restore it on new database it give me error of old database mdf file and ldf file names... (i am using sql server 2008)
January 9, 2009 at 1:13 am
umer (1/8/2009)
can anyone guide me how can i restore database backup of name "cbs_test" to new database "rmsdb" i have created backup of old database and when i try to restore it on new database it give me error of old database mdf file and ldf file names... (i am using sql server 2008)
msdb is the system Database! Can you post the description of the error during restore!
January 9, 2009 at 1:31 am
January 9, 2009 at 5:56 am
Quite honestly I wouldn't fight with it. I would restore the database under the original name "cbs_test"; then right-click on the database and rename it. It should make the proper changes for you and would save less time.
***************
wnylibrarian
Buffalo, NY US
January 9, 2009 at 6:34 am
Have you tried the restore statement using the WITH MOVE option to change the physical file names?
January 9, 2009 at 10:28 am
nwlibrarian (1/9/2009)
Quite honestly I wouldn't fight with it. I would restore the database under the original name "cbs_test"; then right-click on the database and rename it. It should make the proper changes for you and would save less time.
Uh, careful now. Doing this will restore the DB over top of the original!
Umer, what is the error that your getting? Nicholas is most likely correct here. You'll need to restore the DB using the WITH MOVE option.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply