DB Backup Job Failed (SE)

• Elaya-535392

  Old Hand

  Points: 378

  More actions

  August 27, 2009 at 1:38 am

  #209926

  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.

• ankur_libra

  Hall of Fame

  Points: 3999

  More actions

  August 28, 2009 at 5:11 am

  #1046109

  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:-)