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.
Bambola.
Refer to this posthttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=3278 Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>