Verifying Backups

Verifying a backup involves checking the backup set to ensure that all files have been written and that the files in the backup are readable. Although not required, verifying a backup checks that the backup is intact physically, and that you can rely on your backup in the event you need to use it. However, verifying a backup does not check that the structure of the data contained within the backup set is correct. For example, although the backup set may have been written correctly, it may be possible for some type of database integrity problem to be present within the database files that comprise the backup set. To verify the structure of the data before creating a backup, database consistency checks can be performed. For more information about running database consistency checks, see DBCC CHECKDB or the Database Maintenance Plan Wizard.

To verify the backup set

         

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.