Take the 2-minute tour ×
Server Fault is a question and answer site for professional 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
add comment

3 Answers 3

up vote 7 down vote accepted

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

share|improve this answer
add comment

Change the recovery model of the model system database.

share|improve this answer
add comment

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
add comment

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.