x

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.

more ▼

asked Feb 11 '10 at 03:18 PM in Default

Katie 1 gravatar image

Katie 1
1.4k 129 163 202

(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 '10 at 04:45 PM

Blackhawk-17 gravatar image

Blackhawk-17
11.8k 28 30 35

(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 '10 at 03:35 PM

Ian Roke gravatar image

Ian Roke
1.7k 29 33 34

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 '10 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 '10 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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1936
x124
x13

asked: Feb 11 '10 at 03:18 PM

Seen: 3011 times

Last Updated: Feb 11 '10 at 05:37 PM