0

I purged about 100 GB on 200 GB SQL Server v11 DB. The MDF file still show about 200 GB in the file explorer.

Everything looks fine, first tests shows 50% time treatments increase and the backup's size are reduced.

Do you think shrinking is still interesting ? If yes what could be the best way ?

  • Release unused space,
  • Reorganize pages before releasing unused space (shrink file to : X MB),
  • Empty file by migrating the data to other files in the same filegroup.

Index Reorganize/Rebuild, then Update Stats is planned anyway after this operation.

Thanks for help

0 Answers0