My database is 825 GB on disk, but unallocated space is about 500 GB (825GB * 55%).
After I shrank the database and files in SQL Server Management Studio, it had no improvement to reclaim the total
.mdf file size. But I observed the unavailable space increased to 600 GB, total size of the
.mdf file still was 825 GB (before shrink, I rebuilt the the index of tables which used to full text index search).
Do I have approach or configuration to reduce or reclaim the unallocated space (available space)?
- Recovery mode: Simple
- SQL Server 2016 CU15