Post reply

Simple model for master/msdb

  • February 23, 2005 at 5:47 am

    #362082

    Hello,

    Can someone give me a definitive answer on why i should leave master/msdb on simple recovery (or not).

    I have changed them to full. New jobs/alerts and databases are created throughout the day.

    Thanks

    mark

  • February 23, 2005 at 7:48 am

    #543699

    There's another discussion on this here:  http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=131125

    Basically, the recovery model of MSDB is going to revert to simple on each restart so you have to have some mechanism in place to deal with this or your scheduled log dumps will fail after a restart because the DB will be back in simple recovery mode.  Hope this helps. 

     

    My hovercraft is full of eels.

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

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