Categories
Server

How to purge transaction log file in SQL Server

  1. Right click Database
  2. Select “New Query”
  3. Type below SQL script

ALTER DATABASE DBName SET RECOVERY SIMPLE

GO

DBCC SHRINKFILE (XXXX_log, 5)

GO

ALTER DBName dw SET RECOVERY FULL

GO

4. Run “Execute”