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.
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.
answered Feb 11, 2010 at 04:45 PM