rjrumfelt
15 years agoLevel 6
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...
- 15 years agoThe 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