Restore a database snapshot on another server

Question

Question by Katie 1 · Feb 11, 2010 at 03:18 PM · sql-server-2005 administration database-snapshot

Restore a database snapshot on another server

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.

1

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2010-02-11T16:45:08Z

Best Answer

Answer by Blackhawk-17 · Feb 11, 2010 at 04:45 PM

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.

2 · Share

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2010-02-11T15:35:20Z

Answer by Ian Roke · Feb 11, 2010 at 03:35 PM

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.

0 Show 2 · Share

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Katie 1 · Feb 11, 2010 at 03:41 PM 0

Share

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/

Ian Roke · Feb 11, 2010 at 03:48 PM 0

Share

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.

Restore a database snapshot on another server

2 Replies

Your answer

Follow this Question

Related Questions