I just found out that mdf and ldf ARE defragged even with SQL server running, you can see that with the defrag tool.
Brad -----Original Message----- From: Bradford T Comer [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 3:54 PM To: SQL Subject: RE: automating sql service 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:> Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
