BAckup job getting failed

  • The job getting failed everyday which is used to take Full DB backup with the below error.

    sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

  • Add an output file to the Job Step (Edit Job Step --> Advanced). This will give more details on the job failure

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • Can you post the results to the following:

    SELECT * FROM msdb.dbo.sysdbmaintplan_history

    This will give you a much greater detailed message as to why the job is failing.

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

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

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