Problem StatementThe transaction log for database is full due to LOG_BACKUP.
SolutionYou can truncate the transaction log file size using below SQL command sequence in SQL 2012.
- Login in database server.
- Select the database
- Click on new query
- Execute following SQL commands (replace the 'databasename' with your database name at all places in below commands.
ALTER DATABASE [databasename] SET RECOVERY SIMPLE
DBCC SHRINKFILE ([databasename_Log], 5)
ALTER DATABASE [databasename] SET RECOVERY FULL