July 20, 2013 at 12:16 pm
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.
July 20, 2013 at 12:25 pm
If the drive is 40GB and your logs only take up 1.5GB, its not the logs causing the problem, so no need to shrink them.
Ask your server admins to look at the drive, probably hidden files on there, possibly the swap file, which should be moved elsewhere.
---------------------------------------------------------------------
July 20, 2013 at 1:12 pm
George,
You're absolutely right! Didn't think of that. I used windirstat and there are some files from the backup client there.
thank you.
July 21, 2013 at 2:29 am
Please read through this - Managing Transaction Logs[/url]
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply