This is sample for resize a SQL Server transaction log.
USE AdventureWorks;
GO
-- Truncate the log by changing the database recovery model to SIMPLE.01 ALTER DATABASE AdventureWorks
02 SET RECOVERY SIMPLE;
03 GO
04
05 -- Shrink the truncated log file to 1 MB.
06 DBCC SHRINKFILE (AdventureWorks_Log, 1);
07 GO
08
09 -- Reset the database recovery model.
10 ALTER DATABASE AdventureWorks
11 SET RECOVERY FULL;
12 GO
