Database Maintenances plan

• perveen.khan

  Valued Member

  Points: 55

  More actions

  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

• gcp777

  Ten Centuries

  Points: 1079

  More actions

  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.

• perveen.khan

  Valued Member

  Points: 55

  More actions

  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