DB Backup Job Failed (SE)

  • Hi,

    I've scheduled DB backup & integrity checks job for some 12 DB in the single maintenance plan.

    Since one year it was working fine. But last 2 days it is giving an error msg in job history like

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

    DB Backup & Integrity checks was happened perfectly.

    Even in the Maintenance Plan History also there is no failed flag.

    Can any one please help me to sort out this.

  • Hi,

    It can be related to any of the following reasons:

    1. Did someone changed Job owner password recently?

    2. Check whether Job Owner has access to the server or not.

    Please check the SQL Log files and Server EventViewer file and find exyra information.

    Check http://www.sqlservercentral.com/Forums/Topic591012-24-1.aspx for further information.

    Ankur:-)

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

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