SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

SQLJames
Starting Member

30 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

http://msdn.microsoft.com/en-us/library/ms191002.aspx

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

USA
1754 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

jeffw8713
Aged Yak Warrior

USA
798 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

SQLJames
Starting Member

30 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

SQLJames
Starting Member

30 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.

James
Go to Top of Page
  Previous Topic Topic Next Topic  
 New 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.05 seconds. Powered By: Snitz Forums 2000