System database logging recovery models

  • Bob Griffin

    SSCertifiable

    Points: 5982

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

  • vk-kirov

    SSCertifiable

    Points: 7686

    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

    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

    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

    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

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

  • jim.lawrence

    SSC Eights!

    Points: 955

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

  • tilew-948340

    Hall of Fame

    Points: 3431

    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

    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

    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.

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

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