Physical Log size of SQL 2008 DB not reducing after each transaction log backup
Posted on 2011-10-12
I have a application DB hosted in SQL 2008 (Full recovery), with Transaction log backup scheduled every 2 hours from 7 AM till 10 PM, what we are finding is that the Physical log size continues to grow and is currently at 48 GB. When I check the amount of free physical space by right clicking tasks in SMSS and it says 97% space taken and only 3% free.
But when I check the size of the transaction log backup, it is less than 1 GB.
Since it only 3% free, running DBCC shrinkfile will not work, to regain the remaining 97% of space.
Thanks and Regards.