Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SQLJames
Starting Member
35 Posts |
 Posted - 2013-04-05 : 12:25:39
|
| 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 [url]http://msdn.microsoft.com/en-us/library/ms191002.aspx[/url] 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
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2013-04-05 : 19:46:43
|
| 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 |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2013-04-08 : 10:33:24
|
| What Edition of SQL Server are you running? What Edition of the tools are you running? |
|
|
|
SQLJames
Starting Member
35 Posts |
Posted - 2013-04-11 : 10:35:37
|
| Management Studio: 11.0.3000.0OS: 6.0.6002Microsoft 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? |
|
|
|
SQLJames
Starting Member
35 Posts |
Posted - 2013-04-11 : 10:42:15
|
| 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 |
|
|
|
|
|
|
Maintenance Plan