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 Plans - Modify does not work !? Expand / Collapse
Author
Message
Posted Wednesday, May 8, 2013 2:46 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, November 17, 2014 3:53 AM
Points: 177, Visits: 419
Hi all,

I have created several Maintenance Plans in the past - I now want to modify one of them .....

So a simple right click on the selected plan and ..... nothing ... ziltch ...

I can Execute and view history ... but not modify - it does appear in the list in a BOLD FONT.

Any help would be appreciated.



________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP

Please don't trust me, test the solutions I give you before using them.
Post #1450452
Posted Wednesday, May 8, 2013 3:01 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, November 17, 2014 3:53 AM
Points: 177, Visits: 419
I have now tested this issue on the Test Server that is running SQL 2008 R2 -

Modify is still in bold - but it does allow me to modify !?

Is there a permissions or "Microsoft Feature" issue here ?


________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP

Please don't trust me, test the solutions I give you before using them.
Post #1450458
Posted Thursday, May 9, 2013 7:30 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 9:05 AM
Points: 1,316, Visits: 2,903
Are you sure you are using an ID that has 'sa' rights?


Post #1451106
Posted Thursday, May 9, 2013 7:43 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Saturday, November 15, 2014 10:17 PM
Points: 1,838, Visits: 1,333
I hate to post other sites on here, but the following is most likely the why and how of what you are running into.

http://paulgrevink.wordpress.com/2011/05/15/ms-sql-2008-r2-issue-impossible-to-modify-a-maintenance-plan/


Chris Powell

George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
Post #1451112
Posted Thursday, May 9, 2013 7:47 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 9:05 AM
Points: 1,316, Visits: 2,903
Another thought is are you sure you are using the Management Studio version the same version as the SQL Server the Maint. plan is on?


Post #1451113
Posted Thursday, May 9, 2013 11:48 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, November 17, 2014 3:53 AM
Points: 177, Visits: 419
Hi -
Yes the user account has privileges and also tried the SA account

-

SSMS is 2008 R2 - Sql Server is running SQL 2005 !

Here's a question on that topic though ... what if I changed/modified the MP in SQL 2012 SSMS..... ? would that be an issue ?

I have 2012 SSMS still installed on my local PC - will try that - just to rule that out.


________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP

Please don't trust me, test the solutions I give you before using them.
Post #1451282
Posted Thursday, May 9, 2013 11:56 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 9:05 AM
Points: 1,316, Visits: 2,903
SteveEClarke (5/9/2013)
Hi -
Yes the user account has privileges and also tried the SA account

-

SSMS is 2008 R2 - Sql Server is running SQL 2005 !

Here's a question on that topic though ... what if I changed/modified the MP in SQL 2012 SSMS..... ? would that be an issue ?

I have 2012 SSMS still installed on my local PC - will try that - just to rule that out.


You could have problems. Use the same version of Mgt Studio for the same version of SQL Server when creating and maintaning Maint plans.



Post #1451283
Posted Thursday, May 9, 2013 12:01 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, November 17, 2014 3:53 AM
Points: 177, Visits: 419
Yes I agree - I think it might be that - as I was testing the BI functions within 2012 - and may have changed the 2005 MP's on the production server - not 100% sure - but possibly.

So the question is - how do I maintain it now if that is the case - to revert back to SQL 2005 SSMS -

I will be upgrading to 2008 next week though - possibly resolve it then.

Thanks for your input.


________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP

Please don't trust me, test the solutions I give you before using them.
Post #1451285
Posted Thursday, May 9, 2013 12:04 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 9:05 AM
Points: 1,316, Visits: 2,903
SteveEClarke (5/9/2013)
Yes I agree - I think it might be that - as I was testing the BI functions within 2012 - and may have changed the 2005 MP's on the production server - not 100% sure - but possibly.

So the question is - how do I maintain it now if that is the case - to revert back to SQL 2005 SSMS -

I will be upgrading to 2008 next week though - possibly resolve it then.

Thanks for your input.


Log into the SQL2005 server and go into Mgt Studio, open up the Maint plan and just do a save and see if it saves it. That may reset it. If not, you may have to delete it and recreate it.



Post #1451286
Posted Friday, May 10, 2013 1:14 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, November 17, 2014 3:53 AM
Points: 177, Visits: 419
Markus (5/9/2013)
SteveEClarke (5/9/2013)
Yes I agree - I think it might be that - as I was testing the BI functions within 2012 - and may have changed the 2005 MP's on the production server - not 100% sure - but possibly.

So the question is - how do I maintain it now if that is the case - to revert back to SQL 2005 SSMS -

I will be upgrading to 2008 next week though - possibly resolve it then.

Thanks for your input.


Log into the SQL2005 server and go into Mgt Studio, open up the Maint plan and just do a save and see if it saves it. That may reset it. If not, you may have to delete it and recreate it.


This is the bit that I cannot do .... when I click on Modify - SSMS does nothing, it will not open the plan ! - which is the problem.

I will upgrade next week to SQL 2008 R2, then check the plans - If I can modify - problem solved, if not, simple enough to recreate.

Thanks


________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP

Please don't trust me, test the solutions I give you before using them.
Post #1451434
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse