Responding to Verifyonly

• firthr

  SSCommitted

  Points: 1606

  More actions

  December 3, 2003 at 3:59 am

  #106709

  Hi SQL Server Savvies,

  As part of my backup job I run a step to verify my backup. How though would you respond/ rerun the backup if it failed. Would you have to place the output into a temp table and check this for not a valid backup set? Or is there another way. Or would SQL Server deem the step as failed if it ddi come up with "not a valid backup set"? I doubt it as it would still have ran the command successfully.

  Any ideas welcommed!

  Rob

• mccork

  SSC-Insane

  Points: 22288

  More actions

  December 5, 2003 at 4:00 pm

  #484938

  Just check for a non-zero value for @@ERROR. 3013 is returned for "not a valid backup set"

  Cheers,

  - Mark

  
  Cheers,
  - Mark