Solved

SQLSERVER scheduled backups require SQLSERVERAGENT service to be running

Posted on 2013-06-18
6
316 Views
Last Modified: 2013-07-06
I have a few SQL databases I'd like to setup scheduled backups for in Enterprise manager (V8) of SQLSERVER 2000 (I believe, it's on a SBS 2003 server)
When I set up the backups I get a warning that SQLSERVERAGENT service must be running for the scheduled backups to run.
I'd like to do this but my concern is that there is limited space on the C drive of this server and I don't want a bunch of new log files filling up the drivespace. Is this something I should be concerned with?
0
Comment
Question by:bwierzbicki
[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
  • 2
6 Comments
 
LVL 51

Accepted Solution

by:
Mark Wills earned 500 total points
ID: 39269858
Well, sqlagent itself wont create a whole pile of logs, and any maintenance plan you can specify where to put backup logs (and how many to keep)

So, turning on / enabling sqlagent wont be a big impact in disk itself, but, if you C: drive is getting so critical that it raises your concern, then maybe time to have a long hard look at what is consuming c: drive and release some pressure for yourself.
0
 
LVL 51

Expert Comment

by:Mark Wills
ID: 39269864
Also, just be aware that sql 2000 is at the end of extended support.

see : http://support.microsoft.com/lifecycle/search/?sort=PN&alpha=SQL

You might want to consider a bit more than just disk space...
0
 
LVL 58
ID: 39269925
As has been said, SQL Agent itself won't create a lot of logs.

I would however add a purge history on your jobs as a tasks so you clean up maintenance history on a regular basis.

Jim.
0
 
LVL 49

Expert Comment

by:PortletPaul
ID: 39270095
SBS 2003 also has support concerns, see
http://support.microsoft.com/lifecycle/search/default.aspx?sort=PN&alpha=Windows+small+business+server+2003&Filter=FilterNO

if/when you upgrade past sql server 2000 you may also want to visit
http://ola.hallengren.com/ for his excellent (and free) maintenance scripts
0

Featured Post

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.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

627 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