Symptom
You wanted to shrink the transaction log files using the SQL Management Studio. Unfortunately, below error message coming out,
Shrink failed for LogFile ‘XYZ’. The transaction log for dataabse ‘XYZ’ is full due to ‘LOG_BACKUP’
Solution
Go to Database Properties (Right click on the database name and select Property). Go to Options and from the right panel, switch the Recovery model to Simple.
Now, re-execute the shrinking process.
