none
recovery model RRS feed

  • Question

  • Hi,

    What should be (recomended)  Recovery model for master,msdb and model databases?

    Regards


    • Edited by biltz Monday, September 2, 2013 9:32 AM
    Monday, September 2, 2013 9:31 AM

Answers

  • Hello,

    As it's best keep it on the default values: master + msdb on "simple"; in common you have only some less transactions in the database, like maintenance history and you won't need a point-in-time recovery option.

    And "model" on "Full", because it's used as template for all new database and so your new DBs are automatically also on "Full" recovery mode.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Marked as answer by biltz Monday, September 2, 2013 9:48 AM
    Monday, September 2, 2013 9:36 AM
    Moderator

All replies

  • Hello,

    As it's best keep it on the default values: master + msdb on "simple"; in common you have only some less transactions in the database, like maintenance history and you won't need a point-in-time recovery option.

    And "model" on "Full", because it's used as template for all new database and so your new DBs are automatically also on "Full" recovery mode.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Marked as answer by biltz Monday, September 2, 2013 9:48 AM
    Monday, September 2, 2013 9:36 AM
    Moderator
  • Leave it to the default recovery model. These are system database don't play with it. 

    You can change the recovery model of MODEL database. Any new database you create would then inherit the new recovery model of MODEL db

    vt


    Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

    Monday, September 2, 2013 9:38 AM
  • Refer the below link:

    http://technet.microsoft.com/en-us/library/ms365937(v=sql.105).aspx


    Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Monday, September 2, 2013 9:40 AM