creating a new database from a different backup?
-
we have a backup of a db that we want to use to create a whole new db.. possible?
-
Are you just trying to make a copy of the database with a different name? If so you just need to RESTORE DATABASE FROM DISK = 'path here', etc.
-
Or in the Enterprise Manager right-click on Pubs database All Tasks -> Restore Database -> And replace the database name in the box "Restore Database As" with your new name. Do not forget to specify a new file names for Database and Log files on Options Tab, "Move to Physical File name" grid.
On General tab select From Device, Select Device and follow the wizard.
After selection is done click View Content button, you may have several backups in the same file, check the correct one.
Try it on your test server first. It is important at the beginning to right-click on Pubs database that is easily replacible, not on your production database in case you make a mistake and do not specify new database name in Restore Database As. Also do not check Force Restore over Existing database on Options tab. It will partly safeguard you agains mistakes.
I would recommend to make a fresh backup of your original production database if restoring to the same server. Just in case you will forget to change any of the original names. It is OK to keep same Logical File Name, but not Physical File Name
Yelena
Regards,Yelena Varsha
-
You may want to run RESTORE FILELISTONLY from disk='pathtobackedupdbfile' to get the logical names of the data and log files from the backup file first.
Then, I would use the WITH MOVE option with your RESTORE unless you want to put the data and log files in the same path from which they were backed up and with the same names.
Good luck!
Patti
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply