Skip to main content
InSource Solutions

TN WW177 Reclaim Free SQL Log Space

InSource_Logo_Transparent.png

Description

 

This article from InSource shows how to run a SQL script (attached) to reduce the disk space occupied by each database log file in the instance of SQL.  Make sure you have valid backups of all databases before making any changes to MSSQL.

  • Author: Lewis Talley
  • Published: 3/31/2017
  • Applies to: MSSQL (various)

Details

Step 1:

Use SQL below to return the space occupied by each SQL log file in the system.  My demo system results were dumped to an excel file so I could compare before and after. My demo image was using 8.5GB before!

DBCC SQLPERF(logspace)

step 1 before.jpg