RSS

Restore Verifyonly

21 Sep

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

 

Leave a comment