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

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.

 

 

 

Advertisements

One comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s