Hi Gail,

I have an update from my hardware guys.

The D: drive is very fragmented and chdkdsk failed, so their solution is to create a new LUN on clean disks format as X: then take SQL offline, copy the entire contents of D: (just MDf/NDF files really) to X: then drop D: rename X: to D: then bring SQL back online.

I wanted to use detach/attach as we have many Db's for different countries so downtime would be just for that country being moved rather than server down until all are copied, although my way would mean we cannot use D: drive

Thanks for youe help.