lcreid / rails-5-jade

Rails 5 with Jekyll and Node on Ubuntu 18.04
MIT License
29 stars 3 forks source link

MS SQL needs simple database recovery mode. #23

Closed lcreid closed 5 years ago

lcreid commented 5 years ago

The model database is in FULL recovery mode, which means all databases created are also in FULL recovery mode. This means the database log files grow forever, and eventually the Vagrant box runs out of space.

In the initial build, we need to do something like:

ALTER DATABASE model SET RECOVERY SIMPLE;
go

The following answer says what to do when your log is big: https://stackoverflow.com/a/18292136/3109926