Log file decrease size #
sp_helpdb DBNAME
USE DBNAME;
ALTER DATABASE DBNAME SET RECOVERY SIMPLE;
DBCC SHRINKFILE (GenAccDotnet_log, 1);
ALTER DATABASE DBNAME SET RECOVERY FULL;
SQL Truncate Log File
< 1 min read
< 1 min read
sp_helpdb DBNAME
USE DBNAME;
ALTER DATABASE DBNAME SET RECOVERY SIMPLE;
DBCC SHRINKFILE (GenAccDotnet_log, 1);
ALTER DATABASE DBNAME SET RECOVERY FULL;