Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :

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

Arunraj Rajasekar Profile Picture Arunraj Rajasekar 1,731
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