sql-replication.md

title	titleSuffix	description	ms.date	ms.subservice	ms.service	ms.topic	author	ms.author	manager	ms.localizationpriority	ms.collection	ms.reviewer
SQL Server replication	Configuration Manager	Use this diagram to start troubleshooting SQL Server replication between Configuration Manager sites	08/09/2019	core-infra	configuration-manager	reference	banreet	banreetkaur	apoorvseth	medium	tier3	mstewart,aaroncz

SQL Server replication

In a multi-site hierarchy, Configuration Manager uses SQL Server replication to transfer data between sites. For more information, see Database replication.

Use the following diagram to start troubleshooting SQL Server 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 Status = 120

Next steps

• SQL Server replication reinitialization (reinit)
• SQL Server performance
• SQL Server configuration