How can we help you today? How can we help you today?

Verifing Backups

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
qsac226
0

Comments

1 comment

Sort by
  • petey
    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.
    petey
    0

Add comment

Please sign in to leave a comment.