System database logging recovery models

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Robert Griffin » System database logging recovery models

System database logging recovery models

Rate Topic

Display Mode

Topic Options

Author

Message

Bob Griffin

Posted Monday, October 19, 2009 9:35 PM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:26 PM
Points: 1,132, Visits: 663

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

Post #805402

vk-kirov

Posted Tuesday, October 20, 2009 12:03 AM

Hall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 1:32 AM
Points: 3,187, Visits: 4,140

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" Smile

Post #805452

jim.lawrence

Posted Tuesday, October 20, 2009 4:57 AM

SSC Eights!

Group: General Forum Members
Last Login: Tuesday, September 06, 2011 8:17 AM
Points: 891, Visits: 22

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

Post #805587

bitbucket-25253

Posted Tuesday, October 20, 2009 6:47 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 9:02 PM
Points: 5,100, Visits: 20,195

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
Before posting a performance problem please read

Post #805634

BudaCli

Posted Tuesday, October 20, 2009 8:05 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, March 27, 2013 9:02 AM
Points: 1,046, Visits: 573

Nice one

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

Post #805740

Steve Vassallo

Posted Tuesday, October 20, 2009 10:09 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, May 02, 2013 12:25 PM
Points: 525, Visits: 215

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

Post #805874

jim.lawrence

Posted Tuesday, October 20, 2009 10:17 AM

SSC Eights!

Group: General Forum Members
Last Login: Tuesday, September 06, 2011 8:17 AM
Points: 891, Visits: 22

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

Post #805877

tilew-948340

Posted Tuesday, October 20, 2009 5:56 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, April 02, 2013 8:28 PM
Points: 555, Visits: 2,137

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!

Post #806199

RichB

Posted Wednesday, October 21, 2009 4:51 AM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 8:59 AM
Points: 1,026, Visits: 750

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.

Post #806369

FargoUT

Posted Thursday, October 22, 2009 11:21 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, October 11, 2011 1:51 PM
Points: 341, Visits: 311

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.

Post #807345

« Prev Topic | Next Topic »

Permissions