Post reply

Database Maintenances plan

  • May 24, 2006 at 2:11 pm

    #67424

    I have created a maintenances plan and five jobs are created along maintenses plan. Four jobs are running fine.  but  the fifth jobs (transaction log is not backing up) I am getting the following error message.

    Server: Msg 22029, Level 16, State 1, Line 0

    sqlmaint.exe failed.

    All replies are appreciated!

    Pk

  • May 25, 2006 at 2:20 am

    #639966

    Are all the databases set to FULL recovery? If there are any in SIMPLE recovery model then the log backup will fail.

  • May 25, 2006 at 9:02 am

    #640080

    GCp7777

    Thank you for your help you were  exactly right. It was set on as Simple recovery the minute I have changed from simple to full recovery job has started to run.

    Thanks you again.

    PK

     

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

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