currently I have 31% free space in my data file, I tried to shrink the file using TRUNCATEONLY ( with no indexes fragmentation ) but the size still the same and it doesn't free the spaces, i don't want to use with NoTruncate option because it create serious fragmentation. I wanted to see if any experts had some advice to accomplish what I've described above.
How Can I Free Space in SQL Log File ?
Resolved
SQL
CM
Community Member July 22, 2016
1 reply
1,552 views
Reviewed by moderators
1 Answer
DBCC SHRINKFILE with TRUNCATEONLY option is there to give back the UNALLOCATED space from the END OF the data file to the OS. May be there is 31% free space in the data file, but that free space may not be residing at the end of the file.