Rows which were modified on primary was reaching to secondary as well. I checked data synchronization and it was fine. But they were using Always On Availability Group. I checked and they confirmed that they were not using service broker. (Near endpoint role: Target, far endpoint address: ”)įrom the above message, we can figure out that there is some system session in SQL which is trying to connect to some endpoint. During my consultancy engagement, my client’s DBA team was checked ERRORLOG and asked me the possible cause of below error about service broker.ĭateTime spid74s Error: 9642, Severity: 16, State: 3.ĭateTime spid74s An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 11.
0 kommentar(er)
