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

ALTER DATABASE [1398]
SET RECOVERY SIMPLE;

-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE ([1398_log], 1);      --  //And MDF file name

-- Reset the database recovery model.
ALTER DATABASE [1398]
SET RECOVERY SIMPLE;

