I recently had a conversation with a SQL Server DBA about making sure that backups do work as expected. And while I try not to use scary tactics to convince people to change their way of thinking, this particular example needed it. I’ve written a blog post about why I don’t trust the “Verify […]
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 […]
Pop quiz: You manage a production database and you need a copy of your backups to restore them on a development environment for application testing or performance tuning. You need to do this on a regular basis. Do you Take a backup of the database and restore it on your development environment? Configure replication between your […]
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 […]
By continuing to use the site, you agree to the use of cookies. more information
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.
