During the Comprehensive Database Performance Health Check, I had also helped the client build a query to list active and inactive VLF.
SQL SERVER – Cannot Shrink Log File 2 (SQLAuthorityDB_log) Because the Logical Log File Located at the End of the File is in Use
Learning never stops for a consultant. In this blog, I would share another learning and discuss message: cannot shrink log file because the logical log file located at the end of the file is in use.
Question: How to Shrink All the Log Files for SQL Server?