Verifing Backups

qsac226qsac226 Posts: 22
edited March 15, 2007 10:57PM in SQL Backup Previous Versions
If i read the spec sheets right, i noticed that the Verify only works if you use the GUI. Is that true?

If so, is there any way to verify the backup?

Thanks
Q
· Share on Twitter

Comments

  • peteypetey Posts: 2,358 New member
    SQL Backup allows you to verify backups from the extended stored procedure, using the RESTORE VERIFYONLY command e.g.

    EXEC master..sqlbackup '-sql "RESTORE VERIFYONLY FROM DISK = [e:\backups\pubs.sqb]" '

    The GUI has an option to run this command after a backup has been made, so it's essentially a BACKUP command, followed by a RESTORE VERIFYONLY command.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
Sign In or Register to comment.