How can I shrink my database files?

  • Page Owner: Not Set
  • Last Reviewed: 2020-01-02

I'd like to save some space on my drive by reducing the size of my SQL server, How can I shrink these files?


Additional Posts

Shrink Log Files

If your database is configured to use a Full recovery model, your log files will grow indefinitely. The quick fix is to set it to a Simple recovery model and shrink the log files. You don't need the Full recovery model for local work.

  1. Right click your database and go to properties
  2. Options -> Recovery Model -> set to Simple
  3. Right click database again
  4. Task -> Shrink -> Files
  5. Set file type to Log
  6. Click OK

Do not do this on any production database or other DB you care about