Fixing Maintenance Plan Error code 0x534

  • Comments posted to this topic are about the item Fixing Maintenance Plan Error code 0x534

    Regards,Ganapathi varma, MCSAEmail:

  • Thanks for the article.

  • 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.

    Got maintenance plans? [/url]

    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