How to change default recovery for new databases?

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.

Leave a Comment