How do I reduce shrink LDF file size in SQL Management Studio?

How do I make my LDF file smaller?

The ldf file does notshrink by itself, or when you produce a log backup. To shrink an ldf file, you use a command called DBCC SHRINKFILE (documented here). You can do this in SSMS by right-clicking the database, select "Tasks", "Shrink" and "Files".

Why is my LDF file so big?

However even in this case if you ever had massive data operations, you may notice that the size of your transaction log (LDF) file is huge. The reason for it is that SQL server does not automatically shrinks the size of transaction log. To keep log file under control, it may be tempting to enable Auto Shrink option.

How can I reduce MDF and LDF file size?

How to Shrink .1Connect to the SQL Server Management Studio, Go to Databases.2Select the desired database that needs to be shrunk.3Right-click on the database, Select Tasks >> Shrink >> Files.4Make sure that you choose Data File type for shrinking MDF File.5The options of Shrink Option are as follows:Steps to Shrink MDF File in SQL Server

How do I make my SQL file smaller?

To shrink a data or log file. 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.