SQL 2008R2 file (database.ldf) will not shrink
Posted on 2013-12-04
I have a database that is about 8gb and a LDF file that is about 5gb. I have a transaction log backup every hour and a full backup once a day. When I was using a previous version of SQL when the full backup was completed the transaction log file would go to a very small filesize.
I have tried to manually shrink the transaction log file and it does not change.
Should the transaction log file get smaller?
Thanks for your help.