How to: Truncate Transaction Log

2.53846
Average: 2.5 (13 votes)
Your rating: None
ALTER DATABASE DBNAME SET RECOVERY SIMPLE;
DBCC SHRINKDATABASE (DBNAME, 5)
ALTER DATABASE DBNAME SET RECOVERY FULL;

https://support.gearhost.com/…ql-2008.aspx

Keywords: MSSQL, Transaction log, Truncate