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.