Daily Archives: March 14, 2011


Database Snapshots – Part 2 – Offload reporting

So now that we know a little bit about database snapshots in SQL Server, what else are they good for?  One thing you can do is use snapshots in conjunction with database mirroring to offload reporting onto another server. Suppose you’re using mirroring as part of a high-availability solution.  Normally that mirrored database/server would sit […]

Mirroringsecondqueryofsynonymsnap2_thumb.jpg