I have a production instance that has 2 AOG. There is no mirroring configured for both groups. Both groups are also in 'Healthy' state.
Upon checking the error log on SQL Server, I noticed that starting from 12/19/20 there has been this error that started at 9:03PM. I went through an dug in further to see that there is a pattern. Every night around 9:03-9:04pm the same error is happening. This does not occur during normal business hours.
Error msg:
An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 11. (Near endpoint role: Target, far endpoint address: '')`
My thought was to stop and restart the endpoints, but I don't think that would be necessary in this case.
Anyone have any thoughts as to why it might be happening on a daily basis around the same time, and how I may be able to solve this error?
Thanks in advance.
