Solved

SQL maintenance plans on SBS2011

Posted on 2011-02-22
6
1,438 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Because virtualization becomes more and more common, and, with Microsoft Hyper-V included in Windows Server at no additional costs, and, most server hardware nowadays is more than capable of running a physical Small Business Server (SBS) 2008 or 201…
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

763 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