When defragging a disk that has never been defragmented, it will require that you do the defragmentation process several times. The larger the drive the more times you will need to run defrag to fully defragment the drive.
You can expect that on a 30 gig drive, where most all of the file space is indicated to be red - fragmented, it will take you upwards of 12 times to fully defrag the drive. Also, the amount of free space on the drive will affect the number of times you will need to do the initial defragmentation. At least 21% free drive space is required to perform the defragmentation process. Each time you run the defragmentation process, you will note that there is more and more blue on the graph. Also, once you have fully defragmented a disk, if you run a scheduled task at least once a week, or greater if your disk is heavily used. When doing this scheduled defragmentation, you will need only run it once each time the task is run. This can be done as a Windows Scheduled Task. FYI from my NA experience! -----Original Message----- From: Danna D. Swain [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 2:24 PM To: SQL 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
