Maintenance plan save - Catastrophic failure

  • Hello,

    I have an existing maintenance plan that reindexes and updates the stats of some tables. I have selected some of the user databases as part of the job (skipping some read only ones). We recently added a database I wanted to include in the plan so in SSMS 2008 I clicked modify on the existing maintenance plan, added the database to the rebuild and update jobs and then when I save it gives a 'Catastrophic error'. I have tried saving a couple of times and closing and reopening SMSS but it does the same thing. Has anyone out there encountered this before?

    SQL Server 2005 Standard - 9.0.3215

    Management studio 2008

  • Try using SSMS 2005?

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

  • Good suggestion, I had my coworker do that shortly after getting the error message and had a different error, will have to get him to do it again as it was different than the catastrophic error.

  • Thanks for the feedback, Gary.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

  • Gary,

    I had the same 'Catastrophic Failure' that you described when editing a maintenance plan using the SQL tools on the actual server. However, I was able to edit and save the changes successfully when using the SQL tools from PC to remotely attach to the server. Having 'done the business' I did not attempt to investigate the root cause of the problem but it looks like a problem with the local install of SSMS.

    Keith

  • I am getting the same error when trying to setup a maintenance plan in SSMS 2008. Does anyone know what this error represents or how to get around it?

    Thanks

    Shay

  • did you check this simple little issue with a couple of the required DLLs not getting registered?

    RegSvr32 msxml3.dll

    RegSvr32 msxml6.dll

  • My vote is to stop using maintenance plans altogether!! They are horrible. Go to ola.hallengren.com and get the FREE goodness there. Complete MX suite, including creating agent jobs for you. FULLY DOCUMENTED and AMAZINGLY FLEXIBLE!!

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • support 62325 (4/14/2011)


    did you check this simple little issue with a couple of the required DLLs not getting registered?

    RegSvr32 msxml3.dll

    RegSvr32 msxml6.dll

    Yes it's an old thread but, this worked for me, Thanks.

    Cheers,

    Nick

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply