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.
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:
It's a bit messy, and there will be some down-time for the database, however.