Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

We have a database server with U2 installed on a windows 2003 server with RAID5 setup. I'm wanting to use Diskkeeper to defragment the different partitions. Has anyone ever ran into any issues or data loss when defragmenting a drive? Are there any dangers when defragging?

share|improve this question

3 Answers 3

up vote 2 down vote accepted

No. Except it makes NO SENSE on a properly conffigured SQL Server (if your partitions are aligned, node size is set correctly to the NOT DEFAULT value).

share|improve this answer
2  
No benefit to the data/log files, maybe. But the rest of the file system benefits just as much as any other system. –  Chris Thorpe Jul 30 '10 at 21:34
    
The rest of the system is irrelevant, though. Seriously. Once SQL is loaded, and if properly configured, the pretty much ONLY load you have is on the data and log files. Which, under proper guideliney, are static in size. –  TomTom Jul 31 '10 at 6:17

You'll be fine.

share|improve this answer

Other than defragmenting the filesystem there may be a way of defragmenting the database itself (i.e. how data are stored inside the database files) . The exact procedure depends on the database product you're using though.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.