Restore a database snapshot on another server


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.


more ▼

asked Feb 11, 2010 at 03:18 PM in Default

avatar image

Katie 1
1.4k 132 164 205

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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.

more ▼

answered Feb 11, 2010 at 04:45 PM

avatar image

12.1k 30 36 42

(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Feb 11, 2010 at 03:35 PM

avatar image

Ian Roke
1.7k 32 35 38

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)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Feb 11, 2010 at 03:18 PM

Seen: 4207 times

Last Updated: Feb 11, 2010 at 05:37 PM

Copyright 2018 Redgate Software. Privacy Policy