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

Backup with verify on a multiple DB scheduled job....

The option to verify isn't available. Is this by design? If I alter the script to perform a verify, will it have a negative impact in some way?
designtoscano
0

Comments

3 comments

Sort by
  • petey
    The VERIFY option is only used by the GUI, to run a RESTORE VERIFYONLY command after the backup has been made. It is ignored when ran from the extended stored procedure or command line.
    petey
    0
  • kolson
    We are eval'ing SQL Backup, and I'm wondering if it is possible to put a second step in my SQL Server Agent job to run Restore Verifyonly as mentioned in the response below. We usually generate jobs to SQL Server Agent for our backups, so if that would still work in a job step that would satisify our needs.
    kolson
    0
  • Brian Donahue
    Hello,

    Sure! You can put a RESTORE VERIFYONLY in a SQL Agent job:

    exec master..sqlbackup '-SQL "RESTORE VERIFYONLY FROM DISK=[file]"'

    You would need to include some sort of RAISERROR or notification in the script so you know that the verify raised an error.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.