Shrink Database Log File

USE [MeAndCultureDB]
GO

-- Truncate the log by changing the database recovery model to SIMPLE.

ALTER DATABASE [MeAndCultureDB]
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE ('WhoWantsToBeMillionaireQs_log' , 100)
GO
-- Reset the database recovery model.
ALTER DATABASE [MeAndCultureDB]
SET RECOVERY FULL;
GO