Hi a little while ago I posted a topic on how to resond to verifyonly, and the answer was:
restore verifyonly FROM DISK = 'db dump'
if @@error = 3013 --3013 = not a valid backup set.
--retry backup one more time!
However verify takes a little too long on very large databases and you can establish even quicker if it is OK if you use a,
"restore verifyonly FROM DISK = 'db dump' "
and look at the BackupName. If it says
*** INCOMPLETE ***
then it has failed. Any ideas though as to how I could respond to this, i.e. have a query which said
if backupName= %incomplete% then job_step = failed
else job_step = success
Ideas as always much appreciated! Rob