Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Maintenance Plan
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

35 Posts

Posted - 04/05/2013 :  12:25:39  Show Profile  Reply with Quote
I am trying to setup a Maintenance Plan for a SQL Server 2012 instance.

I go to Management Studio and expand the Management tree and don't see the Maintenance Plans option. I noted from an MSDN page

that in order to see those options one must be a member of the SYSADMIN server role. I was able to grant myself rights under my login (windows authentication) to be a member of the SYSADMIN role.

I am still unable to see the Maintenance Plans under the Management tree. Am I missing something obvious? Any suggestions are greatly appreciated.

Thank you in advance for your time and consideration.

Bustaz Kool
Flowing Fount of Yak Knowledge

1834 Posts

Posted - 04/05/2013 :  19:46:43  Show Profile  Reply with Quote
Have you tried disconnecting and reconnecting after you changed your rights? Alternately, close Management Studio and re-open.

There are two kinds of light -- the glow that illuminates, and the glare that obscures. -James Thurber
Go to Top of Page

Aged Yak Warrior

819 Posts

Posted - 04/08/2013 :  10:33:24  Show Profile  Reply with Quote
What Edition of SQL Server are you running? What Edition of the tools are you running?
Go to Top of Page

Starting Member

35 Posts

Posted - 04/11/2013 :  10:35:37  Show Profile  Reply with Quote
Management Studio: 11.0.3000.0
OS: 6.0.6002
Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)
Oct 19 2012 13:38:57
Copyright (c) Microsoft Corporation
Express Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2) (Hypervisor)

Does it have to do with the fact that it is express edition?
Go to Top of Page

Starting Member

35 Posts

Posted - 04/11/2013 :  10:42:15  Show Profile  Reply with Quote
Yep, it is because it is Express. What a bummer. I will have to automate the backups with scripts and a scheduler. Thank you for the responses. I appreciate the time you took to write back.

Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000