Home / server / Questions / 205759
In Process
electricsk8
Asked: 2010-11-25 13:25:25 +0800 CST

Defragment a FILESTREAM data container

  • 772

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.

sql defrag filestream

2 Answers

  1. 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

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

    • 0