Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

SQL Server version is as follows :

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86)
Copyright (c) Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

In SQL Server Management Studio, under the Management node, I am unable to view the "Maintenence Folder" node. I am logged in as sa, and the account does have the sysadmin server role.

How do I get access to the "Maintenance Folder"?

share|improve this question
Can you see Maintenance Plans in SELECT * FROM msdb.dbo.sysssispackagefolders;? – user6426 Sep 23 '12 at 12:28
Do you get an error? – Shawn Melton Sep 24 '12 at 2:39
Hi Shawn, I am not getting any error. Unbale to find Maintenance folder – Vinayak Sep 25 '12 at 5:11
Hi Michal, Please see the following result of query : 08AA12D5-8F98-4DAB-A4FC-980B150A5DC8 00000000-0000-0000-0000-000000000000 Maintenance Plans – Vinayak Sep 25 '12 at 6:59
Which version of Management Studio are you using? – Jon Seigel Sep 25 '12 at 22:16
show 3 more comments

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.