If you're talking about scheduled stops & restarts, you can use Windows
Scheduled Tasks to run simple batch files that do the job.

The command within the batch files is: net stop (example: NET STOP
SQLSERVERAGENT)
or net start (NET
START SQLSERVERAGENT)

I have to do this nightly on one of my servers. I run the batch files in
this order:
1. Stop SQLSERVERAGENT
2. Stop SQLSERVER
3. Start SQLSERVER
4. Start SQLSERVERAGENT
The commands run about 5 minutes apart from each other.

Probably there is a more elegant way to do this, but it works for me.

--Chris


-----Original Message-----
From: Todd Stover
[mailto:mssqldba-ezmlmshield-x40757602.[Email address protected]
Sent: Friday, June 30, 2006 8:41 AM
To: LazyDBA Discussion
Subject: automated stopping and restarting of sql services in 2000.


Anyone know how to reliably do this?



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
NOTICE: This transmission may contain confidential health information that
is protected by special federal or state law or regulation. It is intended
only for the use of the individual to whom it has been addressed. Only the
person named in this transmission is authorized to view any information
contained herein. Re-disclosure without proper consent is prohibited.
Unauthorized use or disclosure or failure to maintain confidentiality may
subject you to penalties under both federal and state law.

MS Sql Server LazyDBA home page