How to Shrink the log file (.ldf) in SQL Server Management Studio

  1. To shrink the log in SQL Server Management Studio, right-click on the intended database, then choose Tasks >  Shrink > Files -

  2. On the Shrink File window, change the File Type to Log. Then click the OK button.


Article ID: 1805
Last updated: 09 Sep, 2025
Revision: 1
Windows Hosting -> MS SQL Server -> How to Shrink the log file (.ldf) in SQL Server Management Studio
https://kb.diadem.in/how-to-shrink-the-log-file-(ldf)-in-sql-server-management-studio_1805.html