All we need is an easy explanation of the problem, so here it is.
I’m getting these errors in SQL error logs:
An error occurred in a Service Broker/Database Mirroring transport connection endpoint,
Error: 8474, State: 11. (Near endpoint role: Target, far endpoint address: ”)
Error: 9642, Severity: 16, State: 3.
Principal and mirror servers are in synchronized state. They have been in synchronized state for some months now, but I keep getting these error messages, I checked the permissions and everything is like its supposed to. Timing on both the servers is the same.
How can I stop these error messages. Thanks for your help.
How to solve :
I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.
The mirror state is likely confused at this point and should not be trusted. cherish.j.wang posted the following at: http://www.sqlservercentral.com/Forums/Topic1237273-1549-1.aspx
use master GO alter endpoint endpoint_name state = stopped; GO alter endpoint endpoint_name state = started; GO
In that same discussion Robert Davis (SQL Soldier) agreed that would resolve the problem for the moment. But he also pointed out that if you use the fully qualified domain name of the servers you are less likely to run into a name resolution error.
UPDATE: When you reset the endpoints, it will take the database offline for the duration of the restart. However, it will not break the mirror. The mirroring will stop running when the endpoint is
stopped, but it will resume once the endpoint is again
The MSDN article: http://support.microsoft.com/kb/2490051 suggests.
- Run these commands on the primary
- If it does not resolve the problem, run the commands on the mirror.
- If the database becomes
ALTER DATABASE <Database Name> SET PARTNER RESUME
Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂