Recovery Mode is changing

SQL Server 2000. We set the recovery mode for the msdb to full. When we check it a few days later, recovery mode set itself to simple. No set pattern, no consistency as far as we can see.Originally posted by littleccguy
SQL Server 2000. We set the recovery mode for the msdb to full. When we check it a few days later, recovery mode set itself to simple. No set pattern, no consistency as far as we can see.

Just curious...does it make coffee for you too when you get in in the morning?

Seriously doubt it...

How many people have access to the box?|||I have to agree with Brett ! There has to be someone doing it. Or try running a Tace on MSDB for a week (you can select filters and options to keep the size to minimum)