Reducing LDF size in SQL Server 2008 R2

Posted on 12th February 201828th November 2018 by Tim

Open SSMS
Right click the database in question and select ‘Properties’
Go to “Options” on the left
Change the line “Recovery Model:” from Full to “Simple” and hit OK
Take a full backup of the database
Right click on the database again, go to Tasks – Shrink – Files
Under File Type: select Log and click OK
Take another full backup of the database