Fragmented array

Does anyone have any advice about fragmentation/defragmentation of RAID arra
ys. Basically W2K Defrag reports 80% fragmentation on a partition and our Ne
t Support are unsure whether to defrag it because it is a h/w RAID solution.
As its a SQL Server it fal
ls to me to decide!
CheersJonathan
What is fragmented? Is it your mdf and ldf files, non-database files or ever
ything?
If it is your database files, I would guess you have autogrow on and are gro
wing a very small percentage at a time. It is much better to grow your datab
ase in fewer large files, than lots of little files. Depending on disk space
, when your database needs
to be expanded grow it as much as you can, try for at least 6 months growth
, more if possible.
If that is the case your best bet is to create a new database with large con
tiguous data files. You would then need to copy all your database to it, usi
ng DTS, BCP or similar. You can not use backup and restore as this would re-
create the database in the
same style you have. You could try to create new filegroups and move your da
ta into them and empty the old filegroups and delete them, this can be a bit
messy.
Good Luck
John