So, after much searching and testing I can say with 100% confidence that the procedures I have outlined will work best for reclaiming data space on the MDF file after having implemented FileStreaming. This action can then be followed up by running DBCC CHECKDB to ensure all is well with Of the LDF and then shrink the LDF as I have seen these files grow to 30+GB as a result of shrinking the MDF.Īs stated above, best practice would then be to run an Index Optimizer to Reorganize and/or Rebuild the Indexes that became fragmented due to shrinking the MDF. Therefore, you will need to Shrink the LDF as well, but in our case, we do transaction log backups every 30 minutes, so I usually will kick off a manual backup This action will in turn cause the LDF to grow. Click the Reorganize pages before releasing unused space and chose a value just above the 'Minimum Value Recommended.' The Available free space is show for the MDF.

I have found the best way is to right click on the database, tasks, shrink, files.

Windows 10 reclaim disk space 449