Shutting down the services is good, but may not be enough. I don't have
access to a server right now to verify it, but those files may be marked
as "system", which the defragger skips over. If that's true, reset the
system attribute and it should work.
"Danna D. Swain" <[EMAIL PROTECTED]>
07/31/2003 09:14 AM
Please respond to sql
To: SQL <[EMAIL PROTECTED]>
cc:
Subject: RE: defrag
I did stop all SQL services...
-----Original Message-----
From: Tipton Josh (orl1jdt) [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 9:09 AM
To: SQL
Subject: RE: defrag
You have to shutdown the database server before it will move the files.
Josh
-----Original Message-----
From: Danna D. Swain [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 9:10 AM
To: SQL
Subject: defrag
Do you need some external software to defrag SQL mdf and ldf files such as
DiskKeeper? I have tried to defrag just using the windows utility but the
database files were not defragged.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
