August 5, 2010 at 7:46 am
Hi all
I have one environment with A/P cluster with SQL Server 2005(SP2) and other SQL Server 2005(SP2)
while creating maintenance Plans in A/P cluster with SQL Server 2005(SP2)
I am getting an error
"Method not found: 'Void Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'. (Microsoft.SqlServer.MaintenancePlanTasksUI)"
@@Version information (MSsql2005 version Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition
(64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2) )
But Iam able to create Maintenance Plans in SQL Server 2005(SP2)
I am not geeting any error in other environment
@@Version information ("Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1) )
what is reason creating Error in "Cluster" can some body help out
August 5, 2010 at 8:19 am
I would suggest re-installing SP2 only for Client Components. Please take care not to select "Database Services" and other components.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 21, 2011 at 2:36 am
have you installed sp2 on each node of the cluster. thats what we had to do and it works.
February 22, 2011 at 6:39 am
My advice is to stop using maintenance plans. Get the free and awesome maintenance suite from ola.hallengren.com.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
February 22, 2011 at 7:31 am
the patches are cluster aware which means the engine will be both updated on both sides. the noncluster components like client tools ect will require to run the patch also on the other node. Now i dunno what version of SP2 you are using but in the early version there was a bug in the maintance plan either download it again or hotfix it. more info about it you can read up here:
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply