Read more about the article Can’t shrink log file
Microsoft SQL Server

Can’t shrink log file

On a heavily utilized system with lots of transaction, shrinking the log file may be difficult.

The normal procedure when shrinking the log file, is to first do a backup of the log. Then directly after that try to shrink the log file. But if there are active transactions writing to the log file, shrinking may not be possible, or at least not shrinking as much as expected.

(more…)

Continue ReadingCan’t shrink log file