Fix : The transaction log for 'AxDB' is full due to 'LOG_BACKUP'

To shrink log file size in development environment, run below query in SSMS against AxDB. Below query will shrink the log file to 1 MB

USE AxDB;

Go

 

ALTER DATABASE AxDB

SET RECOVERY SIMPLE;

GO

 

-- enter log filename below

DBCC SHRINKFILE (filename_log,1);

GO

 

ALTER DATABASE AxDB

SET RECOVERY FULL;

GO