web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / Arunraj's Microsoft Dynamics 365 Finance an... / Fix : The transaction log f...

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

Views (126)
Arunraj Rajasekar Profile Picture Arunraj Rajasekar 1,743
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

Comments

*This post is locked for comments