I would guess you would have to mirror the hard drive or server. Also, it was my understanding that NTFS didn't fragment, or that it didn't affect it's performance. Of course, this could be MS hype.

BOb


>For various reasons, the files of a SQL database have to be defragmented. I am referring to the physical file fragmentation (not internal data/page fragmentation of a database/table) on disk.
>
>Defragmentation utilities, like DiskKeeper, can do the job, but require that SQL server be shut down during defragmentation. As this is not possible in most cases, how is defragmentation accomplished in 24x7 operations? Is it necessary? Does anyone have any experience with this issue?
>
>This is a question I asked about a year ago. I was wondering if any new advances or changes have been reported in this issue. I came across this article: http://www.dmreview.com/editorial/dmdirect/dmdirect_article.cfm?EdID=5658&issue=082302&record=3 which mentions that one should definitely defragment frequently.
>
>Thank you,