November 28, 2008 at 8:26 am
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
November 28, 2008 at 8:53 am
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]
November 29, 2008 at 2:44 pm
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.
November 29, 2008 at 3:05 pm
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]
May 12, 2010 at 5:38 am
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
June 30, 2010 at 4:20 am
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
April 14, 2011 at 12:14 pm
did you check this simple little issue with a couple of the required DLLs not getting registered?
RegSvr32 msxml3.dll
RegSvr32 msxml6.dll
April 15, 2011 at 9:17 am
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
April 22, 2013 at 2:26 am
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