Sql-server – How to change default recovery for new databases

database-administrationsql serversql-server-2012

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

Best Answer

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

From this MSDN doc:

A new database inherits its recovery model from the model database. The default recovery model of the model database depends on the edition of SQL Server. But this can be changed by anyone that has ALTER permission on the database.

Related Topic