SCCM Secondary Site SQL Replication Issue (DRS Issue)

When you see the SQL replication has been failed and try to run replication link analyzer and you get there is an DRS issue with database, try these steps,

Below command will help you to view all SQL replication status
EXEC spDiagDRS – Running this command in SQL Management Studio will show all filed of SQL Replication

If you see the the replication group is disable ot inactive follow the below steps,

• Run this command to remove To service entry from SSB_Dialogpool “delete from SSB_DialogPool where ToService like '%PRIMARYSITECODE' “
• On the Secondary Site create the below two files under C:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box

1. Secondary_Site_Replication_Configuration.pub
2. Secondary Site Data.pub

• Now run EXEC spDiagDRS command again and check if all replications are active