Post reply

sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029).

  • August 13, 2006 at 7:58 pm

    #191941

    Im often getting this error while the executing a db back up job or a db optimization job.

    Can any one give me whats the exact meaning of the error, why am I getting that and how to troubeshoot the error.

  • August 14, 2006 at 9:16 am

    #654892

    Suman,

    I found the following on the internet:

    To resolve DB Maintenance Plan failed with Error 22029.

    CAUSE:

    Selecting the "Backup the transaction log as part of the maintenance plan" option directs SQLMaint.exe to execute a BACKUP LOG command on each database in the plan. Issuing a BACKUP LOG command against a database in SIMPLE recovery model causes the Database Maintenance Plan failed with Error 22029.

    Selecting “Attempt to repair any minor problems” check Box in the Database Maintenance Plan Integrity will also cause the Database Maintenance Plan failed with Error 22029.

    WORKAROUND:

    Open <Database Maintenance Plan> Properties and select <Integrity>.

    Uncheck [ ] the “Attempt to repair any minor problems” check box.

    Uncheck [ ] the “Back up the transaction log of the database as part of the maintenance plan” check box if the database that you’re backing up, is in the Simple Recovery Model.

    NOTE:

    Do not perform transaction log backups in DB Maintenance Plan for database that is in SIMPLE Recovery Model.

     
     
    Rob.

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

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