Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kid_on_the_block
Posting Yak Master
172 Posts |
 Posted - 2006-04-17 : 03:01:29
|
| Hi Can I de-frag the Drive in which the Data files & Log Files of the SQl Server Exists ???Please Advice.Thanks |
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2006-04-17 : 03:03:27
|
| If the drive is in SAN, then no defragmentaion is needed, else you can defrag the drive.RegardssachinDon't sit back because of failure. It will come back to check if you still available. -- Binu |
 |
|
|
Kristen
Test
22859 Posts |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-04-17 : 07:53:33
|
it will defrag but it'll take a very very very long long long time to completeatleast from our experience  --------------------keeping it simple... |
|
|
|
kid_on_the_block
Posting Yak Master
172 Posts |
Posted - 2006-04-18 : 02:26:56
|
| So there is no harm , if I did that right , would not effect the data file , cause I have heard that the Data files should not be place on a compressed file system But the Dr-frag would not be compressing right ???? Anyways thanks !!!!!!!!!!! |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-04-18 : 07:58:12
|
| "But the Dr-frag would not be compressing right"Correct, but unless you have other, non-SQL, files that you want to defrag I wouldn't bother - the effort of trying to defrag whilst the database files are in use will bring the server to its knees!Kristen |
|
|
|
|
|
|
Defrag the Drive