SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server 2012 (Not Express) - Cannot Edit Maintenance Plan


SQL Server 2012 (Not Express) - Cannot Edit Maintenance Plan

Author
Message
RMason - eLIMBS, LLC
RMason - eLIMBS, LLC
SSC-Enthusiastic
SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)

Group: General Forum Members
Points: 159 Visits: 72
Hi there,

We're running SQL Server 2012 (SP 4) build 11.0.7001.0. SSMS is running from the "110" folder, if that helps. The OS is Server 2016 Standard, running RDS. I've tried to recreate the error message I received, but it is no longer coming up (despite *not* hitting "do not show this message in the future" button). The error message I received when trying to modify/edit the maintenance plan was similar to the error message as portrayed in this post:
https://www.sqlservercentral.com/Forums/Topic1699525-3411-1.aspx

Yes, I realize this is for a newer version (12.0, not 11.0), but this was the closest match I could find to the error message at the time...

That being said, I followed the instructions (including ignoring the log file) and found the paths mentioned. Neither of the folders contain any "weirdly named" folders nor do they contain the referenced "ssms.exe.config" file. My guess is that there are no non-standard extensions that have been installed.

I can tell that "MS VS 2010 Shell (Isolated)" & "MS VS 2010 Prerequisites - English" have been installed, but those might not have anything to do with this.

I can get a "Maintenance Plan Wizard" to show, but there is seemingly no response from selecting "New Maintenance Plan..." or "Modify" (on the existing one).

The only reason I even encountered this was that I wanted to verify the number of days it was set to keep backups (thought I'd set it to one month), but it seemed to be keeping too many. Today is right about the threshold where it should start deleting the old .bak files, so I might have jumped the gun a little bit, but the error message and (now) not even responding is concerning to me. I can "View History".

Please let me know if there's any additional information I can provide.

Microsoft SQL Server Management Studio 11.0.7001.0
Microsoft Data Access Components (MDAC) 10.0.14393.0
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.11.14393.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 6.3.14393
Sue_H
Sue_H
SSC Guru
SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)

Group: General Forum Members
Points: 67218 Visits: 13960
RMason - eLIMBS, LLC - Thursday, February 1, 2018 7:19 AM
Hi there,

We're running SQL Server 2012 (SP 4) build 11.0.7001.0. SSMS is running from the "110" folder, if that helps. The OS is Server 2016 Standard, running RDS. I've tried to recreate the error message I received, but it is no longer coming up (despite *not* hitting "do not show this message in the future" button). The error message I received when trying to modify/edit the maintenance plan was similar to the error message as portrayed in this post:
https://www.sqlservercentral.com/Forums/Topic1699525-3411-1.aspx

Yes, I realize this is for a newer version (12.0, not 11.0), but this was the closest match I could find to the error message at the time...

That being said, I followed the instructions (including ignoring the log file) and found the paths mentioned. Neither of the folders contain any "weirdly named" folders nor do they contain the referenced "ssms.exe.config" file. My guess is that there are no non-standard extensions that have been installed.

I can tell that "MS VS 2010 Shell (Isolated)" & "MS VS 2010 Prerequisites - English" have been installed, but those might not have anything to do with this.

I can get a "Maintenance Plan Wizard" to show, but there is seemingly no response from selecting "New Maintenance Plan..." or "Modify" (on the existing one).

The only reason I even encountered this was that I wanted to verify the number of days it was set to keep backups (thought I'd set it to one month), but it seemed to be keeping too many. Today is right about the threshold where it should start deleting the old .bak files, so I might have jumped the gun a little bit, but the error message and (now) not even responding is concerning to me. I can "View History".

Please let me know if there's any additional information I can provide.

Microsoft SQL Server Management Studio 11.0.7001.0
Microsoft Data Access Components (MDAC) 10.0.14393.0
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.11.14393.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 6.3.14393


Did you double check to make sure you installed Management Tools - Complete (instead of Management Tools - Basic)
Do you the same errors in that link you posted about packages failing to load? If so, which packages?
Have you tried a new version of SSMS?

Sue



RMason - eLIMBS, LLC
RMason - eLIMBS, LLC
SSC-Enthusiastic
SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)

Group: General Forum Members
Points: 159 Visits: 72
Thank you for taking the time to read and respond to my question. I am sorry for the delayed response. I had to leave town for an industry convention, and was not checking my emails for several days. I am just now about caught back up.

Did you double check to make sure you installed Management Tools - Complete (instead of Management Tools - Basic)

I'm not really sure how to tell if the version of Management Tools installed was "Complete" or "Basic". Based on (again, an older version) this post on M$'s website, and looking at the available options within my SMS's Obect Explorer, it appears that I have "Complete", but I'm not sure if there's another way to tell...

Do you the same errors in that link you posted about packages failing to load? If so, which packages?

I only have one "package" or "maintenance plan". The "DailyBackup" one listed (partially redacted) in the screenshot above. As mentioned previously, I am not 100% sure what the error message was. It no longer appears, but it was very similar (at least) to the one in the link from my original post. Also, per the same thread, I did not bother looking at the log file, as I was told it would be both huge and pointless.
Have you tried a new version of SSMS?

IT Administration for this client's server is handheld by a third-party group, and I do not have authorization to request that they install a new version of software (as is the case with many groups, they charge by the hour), just for me to double-check a job that is actually working (see original post, where I start with "The only reason"), I just can't open it up to look at it... I have since verified that the "purge" of old backups is working correctly, but was troubled by the error message, the inability to view/edit the plan, and the (now) lack of subsequent error messages...
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search