Shrink SQL database
In Server Management Studio Right click on the database and go to Properties:
Go to “Options” on the left
Change the line “Recovery Model:” from Full to “Simple” and hit OK
Right click on the database again, go to Tasks – Shrink – Files
Under File Type: select Log and click OK
Change the “Recovery Model:” back to Full.