venablc (12/10/2008)
You can take snapshots of a mirror database and then restore these onto a live reporting database (although not if you are using sql2008 as your mirror database according to this article) however this could be processor and hard-drive intensive. It would also mean your reporting would not be live. If this was not a problem then you could automate a snapshot from the mirror database onto your reporting database nightly for example.
Once you take a snapshot of a mirrored database on the mirror server, how are you restoring that snapshot onto another server?
The Redneck DBA