SQL Server - Shrink the transaction log file

shrink.sql

-- First, create a full backup

sqlcmd -d devel

use devel
go
select name,recovery_model_desc from sys.databases
go
ALTER DATABASE devel SET RECOVERY simple
go
DBCC SHRINKFILE (devel_log , 1)
go
ALTER DATABASE devel SET RECOVERY full
go

exit

-- Now create another backup.
-- AFAIK shrinking made impossible to create a point in time recovery prior to the backup taken earlier.