How to Shrink Database Log File / Truncate Transaction Log in MSSQL Server

Use this method Microsoft SQL Server Management Studio.

• Log into Microsoft SQL Server Management Studio
• Right click on your database.
• Select Properties.
• Click on Options.
• Change the recovery model to Simple.
• Click OK.
• Right-click on the database.
• Select Tasks > Shrink > Database.
• Click OK.
• Right-click on the database.
• Select Properties.
• Click on Options.
• Change the recovery model to Full.
• Click OK.