Forum Discussion

rjrumfelt's avatar
rjrumfelt
Level 6
15 years ago

SQL backup exits status 1 - all child streams successful

After finally getting my SQL backup to connect and start writing data, I noticed that all of the child streams completed successfully, yet the parent job exited with status 1.  I've checked the dbclie...
  • Will_Restore's avatar
    15 years ago
    The SQL-Server automatic backup job initiates the execution of the batch file which queues one or more application backup jobs.  If any application jobs fail and the NUMRETRIES keyword is specified in the batch file, then the failed jobs will retry and may be successful.  When this condition occurs, the automatic job will complete with a status 1 even if all of the application jobs have retried and completed with status 0.
    This is normal behavior. The purpose of an exit status 1 under these circumstances is to alert the administrator that there was a potential issue with the overall backup, even though the end result was success. The administrator may choose to ignore the exit status 1, if the cause of the retry is acceptable in that particular backup environment.


    http://seer.entsupport.symantec.com/docs/316629.htm