Post reply

Model DB is in Full recovery model, whereas rest all the databases are with recovery model as Simple.

  • July 10, 2012 at 6:29 am

    #392705

    hi,

    Can you please let me know the architecture behind creating the model databases (by default) as FULL, rest all the databases in SIMPLE Recovery model?

    Thanks.

  • July 10, 2012 at 6:32 am

    #1510867

    All user databases use the Model DB as their template, so if Model is in FULL recovery the DB will be created in FULL recovery unless you issue an ALTER DATABASE dbname SET RECOVERY SIMPLE command.

  • July 10, 2012 at 6:49 am

    #1510880

    why not all the system databases are created with FULL Recovery model?

    What is the architecture behind?

    Thanks.

  • July 10, 2012 at 6:56 am

    #1510883

    Google has plenty on the topic,

    but this should start you off on your search

    http://msdn.microsoft.com/en-us/library/ms365937%28v=sql.105%29.aspx

  • July 10, 2012 at 7:00 am

    #1510885

    Sourav-657741 (7/10/2012)

    why not all the system databases are created with FULL Recovery model?

    Master can't be in full recovery

    TempDB can't be backed up

    MSDB is not usually important enough to need point-in-time restore, if it is in your case, set it to full 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 5 posts - 1 through 4 (of 4 total)

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