In a previous blog post, I talked about the importance of using the CHECKSUM keyword in the BACKUP DATABASE command to make sure that you are not caught unaware of page corruption in your backups. I’ve also provided a very simple example of showing how this one keyword can influence whether or not you’ll have a good […]
PostThe Scariest Lie We Believed About Backup Verifications
Have you ever done something for a long time believing it to be true but actually isn’t? You know, something like going over 10% of the speed limit when you’re driving and thinking that you’re not over speeding? I’m guilty of this myself. But what’s even worse is that there are a lot of information on the […]
PostIs a Successful Backup Really a Successful Backup?
There are two common types of backups performed on SQL Server databases. The first is the native backup type that is commonly taken using either the out-of-the-box database maintenance plans or a custom backup script. The second type is that which is taken by third-party backup tools – be it an enterprise-wide backup tool or a SQL […]
