NEWReplication Issue from Primary Site to All Secondary Sites

KyleASimpz

KyleASimpz

Well-Known Member
51
0
6
好afternoon,

I'm running into replication failed issues since June and looking for advice.

The server we had the main database on crashed and it was restored to a week prior to the crash and now the replication links from the primary site to the secondary site have failed.

1692388665072.png



1692562884682.png


1692562996995.png

1692563070508.png

1692563088596.png


In the database we get:

Message
Service Broker login attempt failed with error: 'A previously existing connection with the same peer was detected during connection handshake. This connection lost the arbitration and it will be closed. All traffic will be redirected to the previously existing connection. This is an informational message only. No user action is required. State 80.'.

I've tried numerous SQL commands and see a lot of "NULL" records.

In the rcmctrl.log I see below.

Error: Replication group "Secondary Site Data" has failed to initialize for subscribing site *blank*, setting link state to Error.
Error: Replication group "Secondary Site Data" has failed to initialize for subscribing site *blank*, setting link state to Error.
Error: Replication group "Secondary Site Data" has failed to initialize for subscribing site *blank*, setting link state to Error.
Error: Replication group "Secondary Site Data" has failed to initialize for subscribing site *blank*, setting link state to Error.

An help will be great.

Attachments

  • 1692388639878.png
    1692388639878.png
    34.4 KB · Views: 1
Last edited:

Latest posts

Forum statistics

Threads
5,723
Messages
22,305
Members
12,505
Latest member
Squuiid