- 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