This is something everyone of us give least preference and times feel this is not required at all, confident on our latest backup taken.. How many of us faced the embarrassing situation on the D day when we need to restore the a latest backup available and to our surprise, BACKUP does not work.
Although not required, verifying a backup is a useful practice. Verifying a backup checks that the backup is intact physically, to ensure that all the files in the backup are readable and can be restored, and that you can restore your backup in the event you need to use it. It is important to understand that verifying a backup does not verify the structure of the data on the backup. However, if the backup was created using WITH CHECKSUMS, verifying the backup using WITH CHECKSUMS can provide a good indication of the reliability of the data on the backup
use RESTORE VERIFYONLY
Restore verifyonly Verifies the backup but does not restore it, and checks to see that the backup set is complete and the entire backup is readable. More info on RESTORE VERIFYONLY can find on below URL.
http://msdn.microsoft.com/en-us/library/ms188902.aspx
Although not required, verifying a backup is a useful practice. Verifying a backup checks that the backup is intact physically, to ensure that all the files in the backup are readable and can be restored, and that you can restore your backup in the event you need to use it. It is important to understand that verifying a backup does not verify the structure of the data on the backup. However, if the backup was created using WITH CHECKSUMS, verifying the backup using WITH CHECKSUMS can provide a good indication of the reliability of the data on the backup
use RESTORE VERIFYONLY
Restore verifyonly Verifies the backup but does not restore it, and checks to see that the backup set is complete and the entire backup is readable. More info on RESTORE VERIFYONLY can find on below URL.
http://msdn.microsoft.com/en-us/library/ms188902.aspx
