Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Can't reclaim space on log files Expand / Collapse
Author
Message
Posted Saturday, July 20, 2013 12:16 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 2:13 PM
Points: 38, Visits: 305
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.
Post #1475765
Posted Saturday, July 20, 2013 12:25 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:29 AM
Points: 5,973, Visits: 12,872
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.


---------------------------------------------------------------------

Post #1475766
Posted Saturday, July 20, 2013 1:12 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 2:13 PM
Points: 38, Visits: 305
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.
Post #1475767
Posted Sunday, July 21, 2013 2:29 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:14 AM
Points: 42,412, Visits: 35,479
Please read through this - Managing Transaction Logs



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1475804
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse