SQLTeam.com | Weblogs | Forums

SQL database mirroring



We are planning to use SQL database mirroring without a witness server and Synchronous mirroring.
From what I can understand the mirror is running in "No Recovery" mode, is it possible to do the backups and querying from the mirror database?




you cannot query directly, but I believe (if I remember correctly) you can take a DB snapshot and query that. However, its only a snapshot, so you cannot get the latest data from mirroring after the snapshot created.