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