Why Msdb has simple recovery model?

Question

Viewing 6 posts - 1 through 5 (of 5 total)

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

Suresh B. SSC-Insane Points: 22986 More actions · Answer 1

In my huble openion:

Because you don't need point in time recovery of msdb database.

It does not contain OLTP data.

forsqlserver SSCoach Points: 18902 More actions · Answer 2

and Why Model database is full recovery mode?

Thanks

Suresh B. SSC-Insane Points: 22986 More actions · Answer 3

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.

forsqlserver SSCoach Points: 18902 More actions · Answer 4

SSCoach

Points: 18902

June 7, 2011 at 2:08 am

O yes !!!

Thanks

spaghettidba SSC Guru Points: 105732 More actions · Answer 5

There's no need for FULL recovery model on MSDB:

-- Gianluca Sartori