A forgotten BEGIN TRAN can pin your log for hours. Here is how to find the owner, read its age, and confirm the transaction is the reason.
SQL SERVER – Msg 2555: Cannot Move All Contents of File to Other Places to Complete the Emptyfile Operation
Removing extra TempDB files failed with Msg 2555: Cannot move all contents of file to other places to complete the emptyfile operation. Let me show you the steps.
SQL SERVER – Cannot Shrink Log File 2 (SQLAuthorityDB_log) Because the Logical Log File Located at the End of the File is in Use
From my shrink series: Cannot shrink log file because the logical log file located at the end of the file is in use. Here is what it means and what to do.
SQL SERVER – Cannot Shrink Log File Because Total Number of Logical Log Files
Cannot shrink log file because the total number of logical log files cannot be fewer than 2. Here is what the message means.
SQL SERVER – Information Message: Cannot shrink file in database to xxxx pages as it only contains yyyy pages.
A reader hardcoded 1 GB in my log shrink script and got: Cannot shrink file in database to xxxx pages as it only contains yyyy pages. I explain why it appears.
How to Shrink All the Log Files for SQL Server? – Interview Question of the Week #203
Question: How to Shrink All the Log Files for SQL Server? Here is the script, plus why you should shrink only log files and never data files.
Recording Who Granted What With a Database Audit Specification
Current permissions never say who changed them. Set up a small audit, run a grant, a revoke and a failed attempt, and read the events back.