Shrink Log File

Shrink SQL Server 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

 

 set the file size, say, 1MB.

Then, click OK and you are done.

 

Other SQL Server Solutions to Consider

Truncate SQL Server Log Overview

II. Eliminate SQL Server Log Instructions