When would I use Database Snapshots with Mirroring to create a reporting server?
When would I use Replication instead of Mirroring and Snapshots?
SQL Server · Mirroring · Database Snapshots
A database snapshot gives you a copy of the data as of the time at which the snapshot is created. If you dont need the most recent data, you can do reporting from a snapshot
If your reports needs to have real-time data, you might need to use replication (if you dont want to query from the primary database)
While mirroring mirroed database is nor accessible. but using snaphots you can access it.
But database snapshots are available only with Enterprise Edition of SQL Server
Managed Windows Shared Hosting by OrcsWeb