Test your backups!

The purpose of making a backup is to be able to restore it at some point. Many of the companies I visit do regular backups but haven't ever restored one of them. If you really want to be safe, test the process to pull a SQL Server backup from off-site storage and restore it. I'm watching a company do this right now and they are struggling. We have a trouble ticket open with the backup software vendor to understand why we can't access our backups.


This is a companion discussion topic for the original entry at http://billg.sqlteam.com/2009/01/09/test-your-backups/
1 Like