Danna,
The easiest way is to create stop.cmd and start.cmd batch files
and use the NET STOP / NET START commands to stop or start the services.
Then you can schedule the batch files or include them as commands in the
defrag job.
Thanks,
Eric
"Danna D. Swain" <[EMAIL PROTECTED]>
09/12/2003 03:24 PM
Please respond to sql
To: SQL <[EMAIL PROTECTED]>
cc:
Subject: automating sql service
Is there a way to automate sql services to stop and restart periodically?
I
would like to schedule monthly defrags at night and need to shut down sql
services in order to defrag mdf and ldf files?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:6
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:>
Get the mailserver that powers this list at
http://www.coolfusion.com
