Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How can i configure the database server on our development server so that when new databases are created that they are Simple recovery model by default?

Currently if we remember, when creating a database we have to click on the options tab and select Simple.

In a previous version of SQL i remember that I could set Simple as the default for new databases. How can this be set for Sql Server 2012?

enter image description here

share|improve this question
up vote 12 down vote accepted

Change the recovery mode of the database named "model".

share|improve this answer

Change the recovery model of the model system database.

share|improve this answer

In previous versions you would set that on the model database, which is the "model" for new databases. I'm assuming it's the same in SQL Server 2012.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.