James Anderson had a database which would drop into In Recovery mode a few times throughout the day:
The database in question wasn’t stuck in recovery, it would slip in and out of the status throughout the day. Normally, I would only ever expect to see a database in recovery during a restore or after a service restart. Once recovery is complete, I would not expect to see the database slip into ‘in recovery’ again. I especially wouldn’t expect a database to keep slipping in and out of recovery.
The answer is a true head-slapper. Whose head, I’ll leave up to you…