October 20, 2010 at 3:03 am
Hi,
We have created the job with maintanance plan for taking the backup of the database through light speed 2005 tool.
one of database backup tasks failed on the job but the job status shows as Success even though the backup task failed on it.
I have verified on the job history ,event log,maintanance history and error log file but i could not find the any adept root cause and also verified the sql job advance option on failure action .
Is there any to find the root cause for why the status not updated as failure ?
Thanks in Advance.
October 20, 2010 at 5:52 am
Hi Sudhakara,
Check the job properties if "Quit reporting Success" is selected when the job fails. Add an output file to
the job step. This will give you more details regarding the job failure.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
October 20, 2010 at 9:16 am
@ sudha...
check if you have enabled the option verify backup once finished
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
October 20, 2010 at 9:16 am
Adiga (10/20/2010)
Hi Sudhakara,Check the job properties if "Quit reporting Success" is selected when the job fails. Add an output file to
the job step. This will give you more details regarding the job failure.
Thanks for your reply.
I have verified that too that has been select as failure only and mentioned on my post. Ya i have set the out put file on the job.
October 20, 2010 at 9:19 am
SKYBVI (10/20/2010)
@ sudha...check if you have enabled the option verify backup once finished
Regards,
Sushant
I think i have enabled that option. will check and update you. what would happen if i have enable that .
Do you mean to say that because of that success that job status show as success even if backup failes?
October 20, 2010 at 9:30 am
@ sudha
It happens sometimes that the backup is done but it is not verified to be consistent and so as a whole; job is success but it doesnt have any backup..( this has very less probablity) but ya it occured with me though.
Also, do you have any more steps in the job or just a backup?
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply