- Repost - originally posted 29-05-2012
Model database recovery setting
We see a lot of databases in full recovery that don't need to be. Why? Because the default for the model database (used as the template for creating databases) is full recovery model. This can cause issues with very large transaction log files when the transaction log never gets backed up. To avoid this you can change the model databases' recovery model to simple. Any databases created after this change will then be created in simple recovery model. You would have to change any databases created before this to simple recovery model as well (as long as they need to be in simple recovery).