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
Atsauksmes
https://aka.ms/ContentUserFeedback.
Drīzumā: 2024. gada laikā mēs pakāpeniski pārtrauksim izmantot “GitHub problēmas” kā atsauksmju par saturu mehānismu un aizstāsim to ar jaunu atsauksmju sistēmu. Papildinformāciju skatiet:Iesniegt un skatīt atsauksmes par