Troubleshooting a Failed Maintenance Plan

re: Troubleshooting a Failed Maintenance Plan

Ken Powers — Wed, 12 Jan 2011 18:27:37 GMT

Thanks for posting this. I had the exact same problem with one of my maintenance plans.

re: Troubleshooting a Failed Maintenance Plan

David — Mon, 07 Feb 2011 10:43:41 GMT

Thanks for this. Exact same problem here too.

re: Troubleshooting a Failed Maintenance Plan

PC — Tue, 07 Jun 2011 15:25:59 GMT

Thank you for posting this! You saved me. I had looked up different sites but you got it right on.

re: Troubleshooting a Failed Maintenance Plan

Cris — Thu, 06 Oct 2011 15:19:15 GMT

Thank you. I also had this problem, I did this to myself. I had forgotten about changing "Allow Updates" to 1 and then my plan failed miserably.

re: Troubleshooting a Failed Maintenance Plan

Guillermo — Wed, 26 Oct 2011 13:57:57 GMT

Many thanks for your post. You saved me.

re: Troubleshooting a Failed Maintenance Plan

DatWunGai — Wed, 25 Jan 2012 18:31:24 GMT

Thank you so much for demystifying what is just one of a long, frustrating line of uninformative, and otherwise useless error messages from microsoft!

re: Troubleshooting a Failed Maintenance Plan

Alex — Fri, 06 Apr 2012 06:50:45 GMT

Thanks! That was exactly my case

re: Troubleshooting a Failed Maintenance Plan

Vinit Satam — Wed, 02 May 2012 19:59:51 GMT

Thank you buddy.......

re: Troubleshooting a Failed Maintenance Plan

JP — Thu, 10 May 2012 18:31:20 GMT

Thanks very much for posting. Wish I had found this.

re: Troubleshooting a Failed Maintenance Plan

Venu — Mon, 15 Oct 2012 21:38:39 GMT

Wow... this solution worked like a charm for me..

the error I got is exactly the same and couldn't useful info on other sites. I re-created the subplan, I recreated the whole maintenance plan still I was facing issue at check integrity task. rebuild index was running fine.

Thanks again!

re: Troubleshooting a Failed Maintenance Plan

Flavio — Wed, 28 Nov 2012 15:47:40 GMT

Thank You for the posting.

And for figuring how to decipher another meaningless error message.

I appreciate it !

re: Troubleshooting a Failed Maintenance Plan

Aneesh — Thu, 04 Apr 2013 16:48:06 GMT

If you set a value greater than 60 for 'recovery interval', it throws the same error

http://sequelserver.blogspot.ca/2013/04/sql-server-2008-maintenance-plan-error.html

re: Troubleshooting a Failed Maintenance Plan

saranya — Mon, 06 May 2013 12:59:54 GMT

Maintenance plan tab is not listed in sql server2008. Any solutions for this.