Shrink SQL database

0

0

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.