This operation
- checks to make sure that a backup is intact physically
- ensures that all the files in the backup set is readable and can be restored
- 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
Checks performed by RESTORE VERIFYONLY include:
- That the backup set is complete and all volumes are readable.
- Some header fields of database pages, such as the page ID (as if it were about to write the data).
- Checksum (if present on the media).
- Checking for sufficient space on destination devices.
RESTORE VERIFYONLY FROMDISK=‘c:\sqlskills\broken2005.bck’;
GO
Source:http://msdn.microsoft.com/en-us/library/ms188902.aspx