Setting A Default Recovery Model For Sql Server

Changing the default recovery model (and other settings) for every new database you create on a server is managed by setting the attributes of the “Model” database.

As the documentation states: “A new database inherits its recovery model from the model database.”

In my case, working mostly with test-servers in VMware, it means that I generally change the installed defaults like this:

USE [master]
GO
ALTER DATABASE
[model] SET AUTO_SHRINK ON WITH NO_WAIT
GO
ALTER DATABASE
[model] SET RECOVERY SIMPLE WITH NO_WAIT
GO

image

Advertisements
Posted in SQL

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s