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
Linux/Windows System and SQL Server Database Administrator with more than 4.5 years of experience in Linux Servers administration, Windows Administration, Network Administration, SQL Server Administration, MySQL Administration and SQL Programming.