CODE EXAMPLE FOR SQL

SQL Server log file truncate - Source :NAYCode.com

//****************** Source - NAYCode.com
ALTER DATABASE DATBASE_NAME
SET RECOVERY SIMPLE
GO
DBCC SHRINKFILE (LOG_FILE_NAME_log, size in MB)
GO
ALTER DATABASE DATBASE_NAME
SET RECOVERY FULL