|
hello there is a snapshot of a production SQL SERVER 2005 database taken last week and we need to restore the snapshot onto another server altogether.the user is requesting for the snapshot that was taken lastweek to be restored. Is there any suggestion as to how to do it? Any work around is Any suggestions will be immensely appreciated. Thanks.
(comments are locked)
|
|
Snapshots are "linked" to a database. They are more logical constructs than actual dBs. As such they can not be backed up (or restored). They retain the orginal data from extents that change after the snapshot creation. If your dB isn't too large you can do a series of SELECT->INSERTS from the snapshot to a new dB and backup/restore that.
(comments are locked)
|
|
I am not familiar with snapshot replication but a quick search brought up Backing Up and Restoring Replicated Databases which I hope will give you some pointers. Ian, this is not exactly the replication concept of SQL SERVER but the database snapshots : to give you an exact idea here is the link http://www.simple-talk.com/sql/database-administration/sql-server-2005-snapshots/
Feb 11, 2010 at 03:41 PM
Katie 1
Sorry I stand corrected. Had a look at that article and it looks like something I need to do some more learning on so if you are still struggling I will post back my findings soon. Sorry I couldn't be of more help.
Feb 11, 2010 at 03:48 PM
Ian Roke
(comments are locked)
|
