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 […]
