SQL maintenance plans on SBS2011

I'm implementing a database for the first time in SBS2011 with SQL 2008 R2. I can't figure out how to get transaction logging, full backups & other maintenance to work.
http://msdn.microsoft.com/en-us/library/ms191002.aspx 

Is this not in SBS2011? Is my account not allowed to see this (I'm not the admin)? Or is there some other way to do this in SBS2011?
LVL 4
GordonPrinceAsked:
Who is Participating?
 
lkammerConnect With a Mentor Commented:
Hi,

Yes,

Express edition is does not include the Agent or maintenance plans.

You will need to install another edition to access the SQL Agent.

Cheers

Leon
0
 
lkammerCommented:
Hi,

The account running SQL Server (and in particular) SQL Server Agent Services needs read, write and create privileges to the folder(s) / network location you are attempting to save the Backups to.

Look in Administrative Tools, Services and go to SQL Server and SQL Server Agent and ensure the Account these services run under have the correct privileges.

Hope this helps.

Cheers

Leon
0
 
lkammerCommented:
I think the 17 hour days are starting to get to me...

Just reread the question.

What's the edition of SQL Server?
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
GordonPrinceAuthor Commented:
It's SQL 2008 R2. I don't see where the option you're discussing is. I've attached a 2008 screenshot, along with the 2005 screenshot from another system that has the options.

It's not that the account running the backups doesn't have permission, I don't even see the options to create a maintenance plan. I'm wondering if this is left out of SBS2011. But then how do you manage SQL 2008? Like Express with scripts?


2008.PNG
2005.PNG
0
 
GordonPrinceAuthor Commented:
It's "Microsoft SQL Server Express Edition with Advanced Services (64-bit)", so that's probably the answer, right?
0
 
lkammerCommented:
Hi,

Your user level permissions at server level can alter what is visible within the Management Studio.
If you are not a member of an Role with the required privileges you will be unable to see the Agent or Maintenance Plan.

There is a role installed with each SQL Server instance to access the SQL Agent SQLServerSQLAgentUser

Cheers

Leon

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.