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.
Most viewed
Most recent
Random passwords
Sicu7494?Tisi9869!
Ridu4234!
Baye8549?
Xiwo7809!