I have a DB that has a log file(40GB) that is greater than the data file size(32GB). The log file has 99% of free space. When I execute DBCC shrinkfile statement, my log file size will not shrink. Database is set to Full recovery model. Full backups are being taken daily at midnight. Log backups are being taken hourly. Here is what I did to shrink:
Queried LOG_REUSE_WAIT_DESC to see that it is waiting for LOG_BACKUP
Queried DBCC Opentran ---> No active transactions
Took a manual log backup, then shrunk it. --- > Did not shrink
Set the DB to Simple, then shrunk it. ----> Did not shrink
Did some research online to see what other things I can try and most of the articles say to do the steps above ^. Is there a reason why log files are not shrinking? Thans in advance.
