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

 USE AXDB;  

GO  

-- Truncate the log by changing the database recovery model to SIMPLE.  

ALTER DATABASE AXDB

SET RECOVERY SIMPLE;  

GO  

-- Shrink the truncated log file to 50 MB.  

DBCC SHRINKFILE (ProdAXDB_log, 50);  

GO  

-- Reset the database recovery model.  

ALTER DATABASE AXDB

SET RECOVERY FULL;  

GO