Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL maintenance plans on SBS2011

Posted on 2011-02-22
6
Medium Priority
?
1,470 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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…

660 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