0

Has anyone ever tried to defrag a FILESTREAM data container using the Windows Disk Defragmenter? Does this work without taking the FILESTREAM enabled database offline?

If this doesn't work, can someone recommend an alternate solution (hopefully inexpensive)?

Thanks in advance.

electricsk8
  • 65
  • 5

2 Answers2

0

Try Defraggler or contig - both seem to defrag files that are in use, provided their size doesn't change.

I'm not sure whether they will work for FILESTREAM data containers though, but it's certainly worth a shot.

Make a full backup beforehand, of course.

0

Defragmenting regularly is listed as one of FILESTREAM best practices, so I think you should be fine.

Pawel Marciniak
  • 205
  • 1
  • 4