-- START SHRINK Query
USE CNG_Main;
GO
-- Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE CNG_Main
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 2 MB.
DBCC SHRINKFILE (CNG_Main_Log, 2);
GO
-- Reset the database recovery model.
ALTER DATABASE CNG_Main
SET RECOVERY FULL;
GO
-- END SHRINK Query