Home > Articles > Data > SQL Server

  • Print
  • + Share This

How Will You Verify That the Backups Are Good?

If a database becomes corrupt, you might still be able to back it up. However, you might not. You might not even get a warning message about the corruption. You should run some checks before backup begins, and SQL Server runs many checks internally to detect corruption (and possibly even fix it). But if you don't run the consistency checks or don't check the results first, you can't tell whether your backups are good until you attempt to restore them.

It's a really good idea to periodically test your backups by restoring one to a test server and ensuring that everything is working as expected. This way, you know whether your backups are good and can periodically test your restoration process. SQL Server 2000 includes the capability to verify the integrity of the backup after it's taken. Besides, who has ever heard of database administrators being fired because they were paranoid with their backup and recovery planning?

  • + Share This
  • 🔖 Save To Your Account

Related Resources

There are currently no related titles. Please check back later.