System database logging recovery models

Question

System database logging recovery models

Bob Griffin

SSCertifiable

Points: 5982
More actions
October 19, 2009 at 9:35 pm

#211165

Comments posted to this topic are about the item System database logging recovery models

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

vk-kirov SSCertifiable Points: 7686 More actions · Answer 1

This behavior has been changed in MSSQL 2008 (see "model Database" in BOL 2008: http://msdn.microsoft.com/en-us/library/ms186388.aspx). Now the recovery model of 'model' database "depends on SQL Server edition".

Didn't find anything about this "dependency" 🙂

jim.lawrence SSC Eights! Points: 955 More actions · Answer 2

In SQL Server 2008, the recovery model of the model database is now 'User Configurable'

http://msdn.microsoft.com/en-us/library/ms365937.aspx

Not had a chance to see a fresh install of SQL Server 2008, so no idea if it comes pre-configured with 'full' or with no model defined

Ron McCullough SSC Guru Points: 63877 More actions · Answer 3

jim.lawrence
Not had a chance to see a fresh install of SQL Server 2008

A fresh install of the Developer Edition - which is supposed to be identical to the Enerprise Edition the default is "Full". Other editions - I do not have installed at the present time

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

BudaCli Hall of Fame Points: 3383 More actions · Answer 4

Nice one

What you don't know won't hurt you but what you know will make you plan to know better

Steve Vassallo SSCommitted Points: 1635 More actions · Answer 5

Fresh installs of SQL 2008 Developer and Standard have the model database set to Full.

jim.lawrence SSC Eights! Points: 955 More actions · Answer 6

Cheers chaps. Worth knowing. All grist to the mill, and all that.

tilew-948340 Hall of Fame Points: 3431 More actions · Answer 7

The reason that it is "full" by default is because , if I understood well, the model database must always exist on a SQL Server system.

An other thing I learned, is that "If you modify the model database, all databases created afterward will inherit those changes" Neat!

This is what I like about those questions: learning! Nice question!

RichB SSCrazy Eights Points: 9651 More actions · Answer 8

Model is the "model" for all user created databases. Stick anything in it - users, procs,tables etc and they will appear in all subsequent databases you create. Presumably if you change the recovery model that will carry through.

FargoUT SSC Eights! Points: 853 More actions · Answer 9

Tricky ... I guess it makes sense, and if I'd thought about it more, I would have answered correctly, but I just clicked "master" quickly without thinking.