Improve company productivity with a Business Account.Sign Up

x
?
Solved

SQLSERVER scheduled backups require SQLSERVERAGENT service to be running

Posted on 2013-06-18
6
Medium Priority
?
342 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
  • 2
4 Comments
 
LVL 53

Accepted Solution

by:
Mark Wills earned 2000 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 53

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 59
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 50

Expert Comment

by:Paul
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

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

There’s hardly a doubt that Business Communication is indispensable for both enterprises and small businesses, and if there is an email system outage owing to Exchange server failure, it definitely results in loss of productivity.
The article describes step by step how to validate the SRA software certificate once installed on the Site Recovery Manager server. I hope it will be very useful for all administrators of virtualized environments.
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

608 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