-- 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 say 25 MB…this is a call you need to make based on how much you want to limit
-- this is a call you need to make based on your requirements (backup, available disk space etc)
DBCC SHRINKFILE (CNG_Main_Log, 500);
GO
-- Reset the database recovery model.
ALTER DATABASE CNG_Main
SET RECOVERY FULL;
GO
-- END SHRINK Query