Recently during consulting engagement Comprehensive Database Performance Health Check, my client asked if I knew why they could not shrink the transaction log.
Question: How to Change Database File Size?
Answer: By Shrinking the files. Now, many have a negative opinion about Shrinkfile.
Shrinking the data file is a very bad thing and you can read it. Now let us learn about if Killing DBCC SHRINKFILE Process is safe or not?
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.