Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Maintenance plan save - Catastrophic failure Expand / Collapse
Author
Message
Posted Friday, November 28, 2008 8:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 21, 2010 2:12 PM
Points: 5, Visits: 70
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
Post #610397
Posted Friday, November 28, 2008 8:53 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, June 5, 2014 10:54 AM
Points: 9,902, Visits: 9,480
Try using SSMS 2005?

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #610423
Posted Saturday, November 29, 2008 2:44 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 21, 2010 2:12 PM
Points: 5, Visits: 70
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.
Post #610782
Posted Saturday, November 29, 2008 3:05 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, June 5, 2014 10:54 AM
Points: 9,902, Visits: 9,480
Thanks for the feedback, Gary.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #610788
Posted Wednesday, May 12, 2010 5:38 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 1, 2014 3:43 AM
Points: 1,334, Visits: 773
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
Post #920352
Posted Wednesday, June 30, 2010 4:20 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 23, 2014 7:52 AM
Points: 118, Visits: 173
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
Post #945337
Posted Thursday, April 14, 2011 12:14 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 14, 2011 12:12 PM
Points: 1, Visits: 0
did you check this simple little issue with a couple of the required DLLs not getting registered?

RegSvr32 msxml3.dll
RegSvr32 msxml6.dll
Post #1093723
Posted Friday, April 15, 2011 9:17 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 1:29 PM
Points: 4,343, Visits: 6,149
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 at GMail
Post #1094229
Posted Monday, April 22, 2013 2:26 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 12:41 AM
Points: 18, Visits: 47
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
Post #1444895
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse