Tag Archives : general dba

Database Snapshots – Part 3 – Data Recovery 2

In this final part of our series on SQL Server database snapshots, I’m going to talk about what, I think, is the most forgotten feature/use of snapshots:  data recovery.  If you (or ‘a friend’) makes a mistake and deletes data you shouldn’t have, or perhaps accidentally drops a table, if you have a snapshot, you […]



Database Snapshots – Part 2 – Offload reporting 2

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