Shrink

How to Shrink SQL Server Transaction Log Files using DBCC SHRINKFILE

To shrink the log in SSMS, right click the database, choose Tasks, Shrink, Files On the Shrink File window, change the File Type to Log. ... Shrink th...