1,731
Share
ReportTo 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;
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
*This post is locked for comments