Shrink Log File

Shrink SQL Server Log File

 These instructions detail how to shrink a SQL Server Log File.

I.  Shrink the log file size at the right time

 Immediately after using the SSIS package or Import the data to the database ( highlight the database->Tasks->Import data … ), or Export the data from the database ( highlight the database->Tasks->Export data … ),  shrink the log file to the desired size, for example, 1MB.  That is, highlight the database->Tasks->Shrink->Files

 

Then, click OK and you are done.

 

Other SQL Server Solutions to Consider

Truncate SQL Server Log Overview

II. Eliminate SQL Server Log Instructions