Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

3 Answers 3

up vote 8 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

 
discard

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.