Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL maintenance plans on SBS2011

Posted on 2011-02-22
6
Medium Priority
?
1,489 Views
Last Modified: 2012-05-11
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?
0
Comment
Question by:GordonPrince
  • 4
  • 2
6 Comments
 
LVL 1

Expert Comment

by:lkammer
ID: 34955219
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
 
LVL 1

Expert Comment

by:lkammer
ID: 34955960
I think the 17 hour days are starting to get to me...

Just reread the question.

What's the edition of SQL Server?
0
 
LVL 4

Author Comment

by:GordonPrince
ID: 34959939
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 4

Author Comment

by:GordonPrince
ID: 34961398
It's "Microsoft SQL Server Express Edition with Advanced Services (64-bit)", so that's probably the answer, right?
0
 
LVL 1

Expert Comment

by:lkammer
ID: 34961411
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
 
LVL 1

Accepted Solution

by:
lkammer earned 1000 total points
ID: 34961447
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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question