Is it necessary / recommended to run Windows defrag on servers primarily used for SQL Server 2005?
I have a server (Windows 2003 x64) with quite a lot of data on it split over several volumes - which have never been defragmented. Most of the data is SQL Server 2005 databases - but some is files/documents.
Should I run a windows defrag on the volumes? If so is it necessary to do this with the databases offline?
thanks - reddal