How to restore from a snapshot generated from a mirrored dabase? You setup mirroring from server A to server B. You create a database snapshot on server B (the mirror). Now, at this point you want to know what to do to revert to the database snapshot (for whatever reason).
N/A
WORKAROUND:
You cannot do any type of restore if database mirroring is enabled, the first thing that you have to do is remove mirroring. Now the database on server B is "in restore" (database snapshots cannot be created when the base database is "in restore," ) and you simply issue the RESTORE DATABASE db FROM DATABASE_SNAPSHOT = 'db_ss' and the revert occurs.
If you want to enable mirroring again you need to do a complete backup/restore because the revert (restore) caused a new recovery fork (database checkpoint) to be created.
