SQL Server – “Cannot shrink log file because the logical log file located at the end of this file is in use”

As an occasional DBA and full time troubleshooter, I have had a number of complex interactions with SQL server. Most of the time, I do not blog about them, In this instance I decided to document the solution to this problem for everyone, but also in case I need it again in the future. I […]