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.


Password Generator

Mipi6772!
Vosu7203!
Weci5675!
Yede6520!
Duwe3656!
Fihu2974!

Most recent

Most viewed