Solved

SQLSERVER scheduled backups require SQLSERVERAGENT service to be running

Posted on 2013-06-18
6
296 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
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 57
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 48

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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

770 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