March 23, 2016 at 10:04 pm
Comments posted to this topic are about the item Fixing Maintenance Plan Error code 0x534
Regards,Ganapathi varma, MCSAEmail: gana20m@gmail.com
March 24, 2016 at 6:51 am
Thanks for the article.
March 24, 2016 at 10:52 am
Thanks. I tried to use maintenance plans sometime around SQL 2005. I remember writing T-SQL to manually edit the XML for a plan so that it could be migrated to another instance. (Imbedded metadata prevented it from working after it was moved.) I also remember running out of disk space often because the cleanup would only run after all databases where successfully backed up - not after each database was successfully backed up. And then there was that issue with calculated columns. Out of frustration, I found Ola Hallengren's maintenance solution based on T-SQL jobs. It's worked like a charm. I'll probably retire before I consider going back to maintenance plans.
PS The "Delete old maintenance plan and re-create the maintenance plan" part was the main reason I went with T-SQL. T-SQL tends to be reliable and portable.
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply