Skip to main content
InSource Solutions

TN WW133 How to Truncate Log Files on SQL Server

  1. Last updated
  2. Save as PDF

insource logo large.jpg

 

Description

Truncating log files in SQL to conserve disk space and improve performance.

 

  • Author: Ernest Lee
  • Published: 11/25/2015
  • Applies to: SQL 2008/2012

 

 

Details

1. Open 2008 Studio management and select the database that you want to truncate the transaction log files for. In this example we are using the MESDB. 

b1.png

 

2. Next right click on the MESDB and select Task then Backup. The Back Up Database window appears. 

b2.png

 

3. In the Database backup window, change the Backup type from Full to Transaction Log using the drop-down list.

b3.png

 

4. Click Options and use the default settings.

b4.png

 

5. Click OK and the transaction log will be truncated. 

It is highly recommended you add this task to your database maintenance plan.