Recently during consulting engagement Comprehensive Database Performance Health Check, my client asked if I knew why they could not shrink the transaction log. Well, I know how one can find the reason for the nonshrinking transaction log, let us learn that in this blog post.
First of all, run the following script
SELECT name, log_reuse_wait_desc FROM sys.databases
The above script will return the name of the database along with the log_reuse_wait_desc. The column displays the reason transaction log space is currently waiting to clear.
Shrink the Transaction Log
There can be numerous reasons why one cannot shrink the log