Testing backups – Is RESTORE DATABASE…VERIFYONLY good enough?
Is it just me, or does there seem to be a lot of discussion these days about testing backups and having a good restore plan in place, before you need it. You don’t want to be “testing” your backups at 3am during a critical restore operation. Verify Backup Integrity (aka RESTORE VERIFYONLY) So when it [...]
June 4, 2012
Tags: backups, recovery, SQL Server Posted in: Maintenance 
2 Comments
SQL Server A to Z – Recovery Models
I may be on vacation, but the alphabet goes on. We’re up to the letter R and that stands for rest, relaxation, and recovery models! Recovery models define how SQL Server manages the transaction log for your database. You have three options to choose from: Simple, Full, and Bulk-logged. The model you choose will determine [...]
October 20, 2011
Tags: a to z, recovery Posted in: Maintenance No Comments
Database Snapshots – Part 3 – Data Recovery
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 [...]
March 17, 2011
Tags: general dba, recovery, snapshots Posted in: Features, General 2 Comments
