Not able to Modify MAintainace Plan

  • Hi All,

    I am using SQL Server 2008 STD 64 bit edition with Sp1 with cummulative update 2 on windows server 2008 sp2 64 bit. SQL Server version is 2714.

    I have created 4 maintenanace plan, But Iam not able to modify it. It does not give any error but it also does not open the maintenace plan modify window.

    Any one faced this issue? What is the resolution.

    Cheers,

    Got an idea..share it !!

    DBA_Vishal

  • Are you trying to open the plans via Mgmt studio on the actual server or from another machine?

  • Do you receive any errors?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Typically there are two places where i've seen this issue.

    1. The plans were created on a version of SSMS that is different than the one you are using. This is because another machine has been patched above/below yours (usually above), or you have patched your tools since you created the plans.

    2. Someone opened the plans in BIDS/Visual Studio and then they saved them back. Some changes in these tools are not supported by the SSMS designer.

Viewing 4 posts - 1 through 3 (of 3 total)

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