Passionately curious about Data, Databases and Systems Complexity. Data is ubiquitous, the database universe is dichotomous (structured and unstructured), expanding and complex. Find my Database Research at SQLToolkit.co.uk . Microsoft Data Platform MVP

"The important thing is not to stop questioning. Curiosity has its own reason for existing" Einstein

Sunday 15 September 2013

Automation for Testing the Quality of Database Backups

The testing of SQL backup restores is a critical task for the Database Administrator and the backups are only ever as good as the last backup that was tested. A standard process for this could look like

  • Recovery of backup files from storage media
  • Restoration of the database backup
  • Checking the integrity of the backup using DBCC CHECKDB 
  • Inspect the output for corruption.

Some useful articles to help automate this process are;

Backup Verification, Statistical Sampling, And You

Statistical Sampling for Verifying Database Backups

Sample size calculator

To completely automate a backup testing routine that scales as the database population varies is an excellent addition to your toolbox.

No comments:

Post a Comment

Note: only a member of this blog may post a comment.