Question: tsql how to shrink log file?
Answer: In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance.
Expand Databases and then right-click the database that you want to shrink.
Point to Tasks, point to Shrink, and then click Files. ... 
Select the file type and file name.