Post reply

Database Maintenances plan

  • May 24, 2006 at 2:06 pm

    #70411

    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 24, 2006 at 2:36 pm

    #639905

    Is the database in full recovery mode if not it will need to be, if you have chosen all databases (including system) then the failure will be due to the system bases being by default in simple recovery mode.

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

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