Shink SQL Database

shrink-database.sql

USE DatabaseName;
GO
-- Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE DatabaseName
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (DatabaseName_Log, 1);
GO
-- Reset the database recovery model.
ALTER DATABASE DatabaseName
SET RECOVERY FULL;
GO

-- source
-- https://stackoverflow.com/questions/829542/how-do-i-decrease-the-size-of-my-sql-server-log-file/829573#829573