Can anyone help me diagnose why this may have happened? We've got log shipping configured and so the database is in 'Full' recovery mode. This has been working fine for ages, and then randomly it seems to have been reset to 'Simple' recovery, which has broken our log shipping.
This happened about 5 months ago too, we couldn't find any obvious reason for the change so foolishly we chalked it up to a weird one-off and ignored it!
The log viewer shows the change being made, but not how/why it happened. I'm not much of a dba so I don't really know how to dig deeper into finding out what happened and how to prevent it reoccurring.
Discovered the reason that this is happening is because of a flag on our db migration script runner (RoundhousE) which resets the recovery mode to Simple. I hadn't been aware of any deployments that day featuring db migrations (these are fairly uncommon on our system), and I have no idea why the /simple flag was configured on the deployments as they were setup before my involvement. Removing the flag has sorted the problem, and seems to have had no negative repercussions!