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