Posts
Sort by recent activity
Impact of VERIFY on Backups
We have the Backup Option "CHECKSUM" selected, but not "VERIFY"... would "best practices" be to have this option set? If yes, what is the "hit" in terms of processing speed? A lot of our databases ...
SQL Backup Restore Errors (End of File)
It appears all of the backups on our production (aka Prod) and development (aka Dev) servers are bad. While the logs indicate everything backed up fine, when we try to restore the backups we get th...
SQL Backup Error Messages
We recently had an interesting problem. We have a script to restore a lot of backups onto a secondary server. One of the steps is to capture the information about the backup file, i.e., <div>DECLAR...
SQL Backup Logs and fn_dump_dblog()
We had an incident earlier in the week where data was accidentally deleted from a database and we needed to track down when it happened and who caused it. There are a few undocumented functions for...