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

LOG_BACKUP

LOG_BACKUP

Sometimes you may face error “The transaction log for database is full due to ‘LOG_BACKUP’” this error due to your database has been set-up as full recovery model and transaction log becomes full due to LOG_BACKUP. and due to this, you will not be able to perform any transaction on this database.

To resolve the issue, take a transaction log backup and set the database in simple recovery model.

To do so you need to do the following

Change the database model to SIMPLE Recovery

ALTER DATABASE Database_name
SET RECOVERY SIMPLE
GO

Truncate log file

DBCC SHRINKFILE (Database_name, 1);
GO

Reset model to FULL Recovery

ALTER DATABASE Database_name
SET RECOVERY FULL
GO

Leave a Reply

Your email address will not be published. Required fields are marked *