question

sqllover24 avatar image
sqllover24 asked

Always On Instance Service Broker/Database Mirroring transport connection endpoint Error

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.


sqlserveralways-onmirroringsql2014database-mirroring-endpoint
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.