Solved

SQL maintenance plans on SBS2011

Posted on 2011-02-22
6
1,458 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
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 250 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

630 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