Post reply

Transaction log backup job error for db maintenance plan

  • October 13, 2008 at 3:09 am

    #213981

    Hi,

    I'm getting the below message when viewed in the job history of 'transaction log backup' maintenance plan.

    "The job failed. The Job was invoked by Schedule 200 (Schedule 1).

    The last step to run was step 1 (Step 1)."

    Also the below error when viewed in the event log.

    "Error 22029 Database. ... error sqlmaint.exe failed."

    How can I know the cause behind this?

    Although, the error relating to this is not logged in the errorlog.

    thanks in advance 🙂

  • October 13, 2008 at 3:23 am

    #884029

    kindly let me know the SQL Server version 🙂

  • October 13, 2008 at 3:34 am

    #884031

    Duplicate post Please post replies to:

    http://www.sqlservercentral.com/Forums/Topic584776-146-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply