SQL Server Performance Forum – Threads Archive
Recovery Model changing on msdbI am having trouble with the Recovery model on the msdb database. I am trying to set it to Full, but every time I reboot it goes back to Simple. Anyone have this problem before? Thanks, Chris
Hi Chris, I think this is the same subject "msdb database". I posted a bit of a reply in that subject. I’ll see what else I can find out quickly. Chris
Create a job that runs ALTER DATABASE and changes the recovery model to FULL. Schedule it to run when Agent starts. That should do it.
Refer to this posthttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=3278 Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.