SytelineMaster

Use the following script to shrink/truncate SQL database log file USE [Database_Name] GO ALTER DATABASE [Database_Name] SET RECOVERY SIMPLE WITH NO_WAIT DBCC SHRINKFILE(DB_Log_File_Logical_Name, 1) ALTER DATABASE [Database_Name] SET RECOVERY FULL WITH NO_WAIT GO Use the following script to check the file size. USE [Database_Name] GO select name,  size from sys.database_files