Home Forums SQL Server 7,2000 Backups sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed. RE: sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

  • if you contiue to get this error. you should check your DB recovery model. if it is set to simple, then you will get following error:

    Executed as user: <user>. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029).  The step failed.

    Set your DB recover model to FULL.

    I hope this helps in additon all other comments posted.