Yesterday, one of my client send me email stating she is not able to run any query against database.

she was getting below error message –

The transaction log for database ‘xxx’ is full due to ‘LOG_BACKUP’

From error message it’s look like transaction log full issue hence I looked for db property and found database is in Full recovery model and growth is restricted.

Hence I thought, let’s change restricted growth to unlimited but it’s not allowing me and was getting same error message.

I thought to perform Full backup and same error message.

I tried to shrink the log file but same error message.

Finally, I tried to perform t-log backup and it went successfully and there after I am able to shrink the file and change db growth to unlimited

Still, I did not get chance to look reason behind this wired error message but if any of you know please feel free to share.