I have posted similar question here 7 or 8 years ago. Now I am unable to find that post. So asking the same question again.
We have a database with 80GB T-Log file(This is due some unexpected transactions from application for which we have already raised a concern with them) Where as data file is only 100MB.
So I have took a log backup of that database, checked the free space of the log file and it is 98% free.
Then I tried to shrink the file but it did not shrinked.
So I took almost 7 to 8 Log backups. Now I am able to shrink the log backup.
Now My question is why I am not able to shrink the log file after 1st log backup even though 98% free space is there. Why I am able to shrink the log file after n number of log backups.
Thanks and Regards!!