15

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

Valamas
  • 355
  • 1
  • 4
  • 9

3 Answers3

28

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.

David P
  • 103
  • 3
mrdenny
  • 27,074
  • 4
  • 40
  • 68
7

Change the recovery model of the model system database.

Jon Seigel
  • 468
  • 3
  • 18
4

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.

joeqwerty
  • 108,377
  • 6
  • 80
  • 171