Troubleshoot Database Replication Service links

In a multi-site hierarchy, Configuration Manager uses Database Replication Service (DRS) to transfer data between sites. For more information, see Database replication.

Use the following diagram to start troubleshooting DRS replication when a link fails:

Queries

This diagram uses the following queries:

Check if the replication group link is in degraded or failed state

SELECT * FROM RCM_ReplicationLinkStatus
WHERE Status IN (8, 9)

Check if replication group link is recently calculated

DECLARE @cutoffTime DATETIME
SELECT @cutoffTime = DATEADD(minute, -30, GETUTCDATE())
SELECT * FROM RCM_ReplicationLinkStatus
WHERE UpdateTime >@cutoffTime

Check SQL Server maintenance mode

SELECT * FROM ServerData
WHERE SiteStatus = 120

Next steps

• DRS reinitialization (reinit)
• DRS performance
• DRS configuration