Post reply

SQL Server Maintenance Plan

  • July 9, 2009 at 2:39 am

    #132621

    Hi guys

    Backup Jobs created by maintenace task runs successfully but it generates following error message.

    "Executed as user: domain\user. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed."

    checks carried out:

    1. When looked for these jobs in model.dbo.sysdbmaintplan_history table they doen't appear there.

    2. Also, changed scheduled time at which these jobs run just in case if other jobs were trying to use sqlmaint.exe at the same time which cause some locking issues and i get the same results.

    3. Created all jobs from scratch and its still not working.

    Any help would be much appreciated guys.

    Thanks in advance.

    Vivek

    Vivek Shukla - MCTS SQL Server 2008

  • July 9, 2009 at 2:48 am

    #1022219

    k

    ----------------------------------------------------------------
    **"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **

  • July 9, 2009 at 6:07 am

    #1022291

    This can probably help you:

    http://support.microsoft.com/default.aspx?scid=kb;en-us;Q303292

    http://support.microsoft.com/default.aspx?scid=kb;en-us;Q288577

  • July 9, 2009 at 10:18 am

    #1022525

    Hi,

    It's looking like a permission issue.

    To get better idea about error go to Advacced Tab of job and specify a file for the output. BY this you can have a better discription about the problem.

    Ankur:-)

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

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