OT_ is the gain that much with defragging of mdf and ldf files, to warrant shutting down the site for X hours to defrag them?
BtC -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 3:23 PM To: SQL Subject: Re: automating sql service 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:> This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
