The transaction log for database '...' is full due to 'LOG_BACKUP'.

USE [master]
GO 
ALTER DATABASE  <db Name> SET RECOVERY full 
GO
ALTER DATABASE <db Name> SET RECOVERY SIMPLE WITH NO_WAIT;
GO