Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How do I backup a database snapshot, so I can restore it as another database (on same or different server?)

We do not wish to roll back to the snapshot, as we need both versions of the database active for testing upgrade scripts.

share|improve this question

I don't believe you can directly backup a database snapshot, and I can't remember if this is a planned feature for the upcoming new version.

If you don't mind a few extra steps, you can do this:

  1. Make a backup of the live database.
  2. Restore the live database using the snapshot in question.
  3. Make another backup of the live database (which will now match the snapshot).
  4. Restore the live database using the backup made in step 1, to get you back to before you restored from the snapshot.

It's a bit messy, and there will be some down-time for the database, however.

share|improve this answer
The database is about 500GB in size! – Ian Ringrose Jul 11 '11 at 12:13

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.