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 |
|
fwellers
Starting Member
3 Posts |
 Posted - 2010-01-11 : 10:05:10
|
| Hi, I have little experience with sql server. We are running version 8.I'm actually an Oracle and Informix dba.I am trying to restore an existing database to a new database name and am a bit confused.The database name is CommercialServices.I did this:RESTORE FILELISTONLY FROM disk='L:ComServ'and got the list for the names.So I am thinking the command ( to restore it to a new database name of CommercialServices_dev, should be restore database CommercialServices_dev from disk='L:ComServ'with recovery, move 'CommercialServices' to 'I:\Commercialservices_dev.mdf', move 'CommercialServices_log' to 'I:\Commercialservices_dev.ldf'I tried to run that command, but get back that it doesn't know about CommercialServices_dev.If I put the name of the existing database there, I am afraid the restore will try to overwrite the existing one. I am trying to get a copy of it from that backup for dev purposes.Can someone set me straight here ?Thanks !!FloydPeace,Floyd |
|
|
fwellers
Starting Member
3 Posts |
Posted - 2010-01-11 : 11:01:30
|
| Never mind. I got it.restore database CommercialServices_dev from disk='L:ComServ'with recovery, move 'CommercialServices' to 'I:\Commercialservices_dev.mdf', move 'CommercialServices_log' to 'I:\Commercialservices_dev.ldf'Thanks.Peace,Floyd |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-01-11 : 11:23:28
|
Can you highlight the difference to your first posted code please?Because I am old and cannot see any differences.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
fwellers
Starting Member
3 Posts |
Posted - 2010-01-11 : 11:33:26
|
| There is no difference. I noticed that after I posted. that is what had me puzzled. I thought I had the command right the first time, but it wouldn't work. Not sure why. If I remember before, it was complaining about the new database name. <shrug>.Peace,Floyd |
|
|
|
|
|
|
|
|
restore to new name question