SQL - Shrink Log

--backup transaction log - TRUNCATE ONLY
BACKUP LOG Northwind WITH TRUNCATE_ONLY;

--shrink database - TRUNCATE ONLY
DBCC shrinkdatabase (N'Northwind', TRUNCATEONLY );

--check database status
sp_helpdb @dbname = 'Northwind';

--change database recovery mode - SIMPLE
ALTER DATABASE Northwind
SET RECOVERY SIMPLE;