June 18, 2009 at 1:36 pm
I have a SQL 2005 SP3 Ent 64bit on Win 2003 R2 Ent 64bit SP2, we have setup a maintenance plan that is backing up the transaction log of all our user databases, about 200. The maintenance plan failed because two of the dbs were in Simple mode, but the job allways reported success.
Have anybody experienced this?
June 18, 2009 at 1:39 pm
what i can think of is there is a setting in the job. If job step fails, go to next step. just check that out to be sure...
June 18, 2009 at 1:51 pm
You are right, thanks.
It looks like by default the maintenance plans steps are join by "on completion", not by "on success".
I found a doc
http://support.microsoft.com/kb/288577
that imply that the normal behaviour should be when Maintenance Plan failes the job is failing, which I didn't cross my mind that might not be that way.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply