Post reply

Model Database in SQL Server

  • December 19, 2011 at 4:45 am

    #265197

    Hi ,

    I just want to know Why the Model Database is in Full Recovery Model in SQL Server 2005.?

    Regards,

    Venkat

  • December 19, 2011 at 4:48 am

    #1423034

    Do you meant to say, it should not be in Full Recovery model?

  • December 19, 2011 at 5:02 am

    #1423037

    Model is used as a template for creating new databases, any new DB will have the same settings Model does. Microsoft decided (and it's a matter that's generated massive debate) that full recovery should be the default for any new database, hence model is in full recovery.

    You can set it to simple if you remember that it means that any new DB will also be in simple recovery.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 3 posts - 1 through 2 (of 2 total)

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