[MSSQL] Shrink transaction log

 

USE TestDB;  
GO
ALTER DATABASE TestDB
SET RECOVERY SIMPLE;  
GO 
DBCC SHRINKFILE (TestDB_log, 1);  
GO
ALTER DATABASE TestDB
SET RECOVERY FULL;
GO