Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Should sql master be set to simple or full?

Author  Topic 

qman
Constraint Violating Yak Guru

442 Posts
Posted - 2011-03-30 : 12:57:49
What is the default recovery model setting for "model"?
Should it be set to simple or full? I notice the master, msdb, and tempdb are set to simple, model is set to full.

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2011-03-30 : 12:59:16
The default is full. Whatever you want your newly created user databases to use is what model should be using. In prod, we use full. In dev/test/non-prod, we use simple.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site