Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.