Saturday, July 20, 2013

[MS SQL Server] Can't reclaim space on log files

[MS SQL Server] Can't reclaim space on log files


Can't reclaim space on log files

Posted: 20 Jul 2013 05:16 AM PDT

I have a separate drive just for my log files that is 40GB in size. The total size of all my logs are 1.5 GB, yet I only have 500MB free left on the drive. My biggest log file is only 550MB. I have tried a shrink and truncate only. How can I tell which log isn't releasing the space? I have had this same setup on this server for over 2 years and this is the first time I have had this issue. Any input is greatly appreciated.

No comments:

Post a Comment

Search This Blog