I have this maintenance plan scheduled on my SQL Server 08... however, it never runs!

It's been setup for 2 weeks now and I have not seen a single backup created, what am I doing wrong? How do I get this thing to run the backups and other tasks?

enter image description here

  • What does the maintenence plan history show? – joeqwerty Jun 6 '11 at 15:27

Make sure the SQL Server Agent service is running.


In addition to making sure the SQL Server Agent services is started, check these:

  • Make sure that the job is enabled. Maintenance plans create SQL Agent jobs which you can look at via SQL Server Management Studio. You can easily check the SQL Agent to make sure the job is enabled.
  • Make sure the schedule in the job is enabled. Schedules themselves can be disabled independent of the job they belong to.
  • Review the job history to see if the job is running and actually succeeding.
  • If you're confident that everything is enabled and started, then if you have cleanup tasks associated with your job check the retention parameters in the cleanup task to ensure that they are not set to delete the backup(s) that were just done in your maintenance plan.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.