Mohammed Imran Ali (12/11/2012)
Could this be the reason why the log file is not releasing space? Any clarification on this is much appreciated.
The only thing that releases space back to the OS is a shrink file. Nothing else reduces the size of the physical file.
Since the log file is 99% free space, log reuse is working properly and there's no problems here, nothing to be concerned about.
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