Sqlmaint.exe failed [SQLSTATE 42000][Error 22029]

It looks like this problem occurs when your database maintenance plan is trying to create a transaction log backup of a database which is Off-line or when a database is using the Simple Recovery model.

I solved the problem by creating 2 maintenance plans. One for all the Simple Recory model databases with no transactionlog backup and one for all the Full Recovery databases with a transactionlog backup.

The same error is also generated when your disk is full.
Tags:

About author

Vittorio Pavesi

2comments

  1. Anonymous
    6:00 PM

    Would like to say that, i believe this is correct. I found both situations happing on a server i've just taken over maintaining. Freed up some space and moved the transaction log backup time to a more suitable one, boom no problem.

  2. Anonymous
    7:41 PM

    Many Thanks

Post a Comment