April 18, 2007 at 9:40 am
I seem to loses records in one of my table and I am trying to trobleshoot my problem. I would like to restore a backup to a temp database in order to view the records on that day. So my question is can I do such operation, restore a backup to a db with a different name other than the original? Or maybe their is an other way to trobleshoot that one of you might have ?
Thanks,
Ric
April 19, 2007 at 10:56 am
Yes, you can by using the 'with move' option of the RESTORE DATABASE command. See 'RESTORE DATABASE statement' in BooksOnLine. There's an example under '
Greg
April 19, 2007 at 11:01 am
Be sure you alter the file names if you resotre to the same server as it can overwirte your existing database. I would suggest do on another server for safety.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply