Post reply

Maintenance plan problems with SQL Server 2005 SP2 - Help!

  • March 6, 2007 at 9:10 am

    #116466

    Hello,

    I set up a maintenance plan under SQL Server 2005 Standard Edition, SP1, and the installation was recently upgraded to SP2. Now the maintenance plans are failing, and I get errors when I try to open the exisiting maintenance plans or even try to create a new maintenance plan or new job.

    For example, when I try to Modify a maintenance plan, I get:

    =======

    Cannot show requested dialog

    Additional information:

    Unable to execute requested command.

    Method not found: 'Void

    Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'.

    (Microsoft.SqlServer.Management.MaintenancePlanWizard)

    =======

    Strangely, I can see and edit and create maintenance plans on my desktop copy of Management Studio, just not from the servers (it's a clustered environment). We swapped back an SP1 node and the problem disappears, so it definitely appears to be an SP2 issue.

    Does anyone know what is going on with maintenance plans in SP2, and how to resolve this? Can it be resolved by reinstalling client tools, or does it mean reinstalling all of SQL Server, or something else?

    Thanks for any help!

    webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • March 6, 2007 at 12:31 pm

    #693396

    There is some MP issue in SP2 but it is not the one...

    Any way MS releasing hotfix for SP2...

    http://blogs.msdn.com/sqlrem/archive/2007/02/24/Maintenance-Plan-Changes-in-SQL-Server-2005-SP2.aspx

    http://bink.nu/Article9653.bink

     

    MohammedU
    Microsoft SQL Server MVP

  • March 6, 2007 at 11:41 pm

    #693467

    If you downloaded SP2 before March 5th 2007, then you need to download the hotfix for SP2 to fix the issue with maintenance plans.

    They released SP2a to address your problem.

    Christopher Ford

  • March 7, 2007 at 7:45 am

    #693577

    Thanks for the additional information. Do you have a page or a link for SP2a (or is it called the SP2 hotfix - or both)?

    Thanks again,

    webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • March 7, 2007 at 7:48 am

    #693579

    Maybe it is this page?

    Critical Update for SQL Server 2005 Service Pack 2 (KB:933508)

    http://www.microsoft.com/downloads/details.aspx?FamilyId=e2c358a1-ecc4-4c49-8f65-daa6b7800eec&displaylang=en

    -webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • March 7, 2007 at 9:56 am

    #693608

    SP2a is called SP2 - you can't get the previous version any more!

    Are you trying to open the Maintenance Plans with a non-SP2 version of SSMS? If so, try patching your SSMS installation as well.

  • March 21, 2007 at 9:43 am

    #696197

    Hi,

    re-apply SP2,  choose "Client Components" and all should be OK.

  • July 17, 2008 at 7:46 am

    #844391

    Glad I found this fix. I reapplied SP2 client and presto it is fixed. ~ Gary

  • July 17, 2008 at 10:47 am

    #844529

    if you have the original SP2 file sitting around on the network remove it and replace it with the latest so it doesnt get re deployed in future 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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