Database Replication – Link Unknown

Question

Hi Team,

Database replication for secondary servers showing as “Link Unknown”.

Initiated replication link analyzer it says “SQL Server Broker login is missing”  we recreated broker login, but issue occurs again and again. Please help me to apply permanent fix.

 

Regards,

Prasanth Padmanaban

solved 0
Prasanth Padmanaban 2 weeks 2021-04-30T11:55:07+05:30 2 Answers 16 views Beginner 0

Answers ( 2 )

    0
    2021-04-30T13:21:10+05:30

    Hello,

    Had you checked the below logs –

    -Rcmctrl.log – Records the activities of SQL database replication between SCCM sites in the hierarchy
    -Sender.log – Records the activities in case of manual sync of replication groups. This manual replication can be done as part of troubleshooting with .PUB files

    Let’s check what the necessary troubleshooting steps an SCCM admin can perform, I would recommend go through these posts once –

    + https://www.anoopcnair.com/fix-sccm-sql-based-database-replication-config/

    + https://www.anoopcnair.com/sccm-secondary-server-recovery-failed-issue-fix-configmgr/

    + https://howtomanagedevices.com/sccm/315/sccm-replication-issue-sql-based-issues/

    Best answer
      1
      2021-04-30T14:40:25+05:30

      Cannot see any error on rcmctrl.log. We have restarted primary and sec servers now status showing as link active.

      Will monitor for some time, I hope we don’t face issue again.

Leave an answer

Sorry, you do not have a permission to answer to this question .