SQL Server – Validation of Backup
Database backup are insurance policy for a database, we need to ensure that backups created are valid and useful. To validate the backup, we can use following command
Restore verifyonly from <backup device>
When a backups is validated, SQL Server performs the following steps
- Calculated a checksum for the backup and compare to checksum stored in the backup files
- Verify that the header of backup is correctly written and valid
- Transits the page chain to ensure that all pages are contained in the database and can be located
For more details click here
You always post a good and interesting article. I am going to save your page for the next time.
Pingback: SQL Server CE, tips for usage and issue of corruption « D.T. & Assoc. IT Blog
Pingback: SQL Server - Mirror Backup of databases - Varinder Sandhu