Video Screencast Help

MSSQL Backup finishes with status code 1 even though single stream retry was successfull

Created: 21 Apr 2010 • Updated: 22 Oct 2010 | 4 comments

Hi,

I was just wondering if anybody could help me out with a MSSQL Backup problem. We have a MSSQL DB set up with the RETRYTYPE AUTO option which in itself works fine. When a single stream in a multi stream backup fails only this one DB is being retried at the end. Unfortunately the parent job then exits with a return code 1 and not with a return code 0. This unfortunately means that our operating is triggered and ultimately the poor DB admin is being yanked out of bed to see if there is indeed a problem. (Which there isn't but everything excet status code 0 is an emergency problem for our databases)
My question is now, is it normal to get a status code 1 ('It's not a bug, it's a feature') or did we misconfigure something somewhere? Unfortunately my own knowledge about MSSQL is severely limited and the admin DB is directly employed by our customer, so it's a bit complicated to get a simple dialogue started.

Any help with this issue would be greatly appreciated!

Thanks a lot and best regards

Christoph Maier

Comments 4 CommentsJump to latest comment

Christoph Maier's picture

Hi,

thanks for the link, I missed that one (did a MSSQL specific search only)
It's close, we have 6.5.4 currently and it's a MSSQL Database, but I am guessing that the final 'solution' to my problem is the same:

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.

Unfortunately this doesn't help me, but if it indeed works as designed there is little I can do about it. Unless there is a way to change this behavior.

rjrumfelt's picture

out here who has a workaround for that behavior, but it may be that the solution to your problem is that there is no solution.

Will Restore's picture

Status > 1 --> yank DBA out of bed
Status = 1 --> send email to DBA
Status = 0 --> everybody celebrate!

Will Restore -- where there is a Will there is a way