June 7, 2011 at 12:34 am
Why Msdb has simple recovery model?
Thanks
June 7, 2011 at 1:15 am
In my huble openion:
Because you don't need point in time recovery of msdb database.
It does not contain OLTP data.
June 7, 2011 at 1:34 am
and Why Model database is full recovery mode?
Thanks
June 7, 2011 at 1:59 am
Because Model database is used as template to create other user databases (including business critical OLTP).
Model database, by itself does not need point-in-time recovery. But, the user databases created based on Model need point-in-time recovery.
June 7, 2011 at 2:08 am
O yes !!!
Thanks
June 7, 2011 at 2:27 am
There's no need for FULL recovery model on MSDB:
http://msdn.microsoft.com/en-us/library/ms365937.aspx
-- Gianluca Sartori
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy