Recovery Model changing on msdb | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Recovery Model changing on msdb

I 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 post Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.