How Can I free Space in SQL Log File ?

Lincoln Burrows ~ Modified: July 22nd, 2016 ~ ~ 1 Minute Reading

This topic has 1 reply, 2 voices, and was last updated 7 years, 8 months ago by Stephen West.

Viewing 2 posts - 1 through 2 (of 2 total)

Author

Posts
July 22, 2016 at 11:17 am #2644 Score: 0

Lincoln Burrows
Moderator

Karma: 16 pts

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.

August 9, 2016 at 1:51 pm #3021 Score: 0

Stephen West
Moderator

Karma: 4 pts

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

Posts

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.