Maintenance plan save - Catastrophic failure

Question

Maintenance plan save - Catastrophic failure

Gary Butts

SSC Enthusiast

Points: 101
More actions
November 28, 2008 at 8:26 am

#125240

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

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

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

RBarryYoung SSC Guru Points: 143329 More actions · Answer 1

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]

Gary Butts SSC Enthusiast Points: 101 More actions · Answer 2

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.

RBarryYoung SSC Guru Points: 143329 More actions · Answer 3

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]

Keith Batty Default port Points: 1486 More actions · Answer 4

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

shaycullen Right there with Babe Points: 781 More actions · Answer 5

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

support 62325 Valued Member Points: 65 More actions · Answer 6

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

RegSvr32 msxml3.dll

RegSvr32 msxml6.dll

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 7

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

Nick Jacobsen SSC Rookie Points: 40 More actions · Answer 8

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