title | titleSuffix | description | ms.date | ms.subservice | ms.service | ms.topic | author | ms.author | manager | ms.localizationpriority | ms.collection | ms.reviewer |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Global data reinit |
Configuration Manager |
Use this diagram to start troubleshooting SQL Server replication reinit for global data in a Configuration Manager hierarchy |
08/09/2019 |
core-infra |
configuration-manager |
reference |
banreet |
banreetkaur |
apoorvseth |
medium |
tier3 |
mstewart,aaroncz |
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 reinitialization (reinit) for global data in a Configuration Manager hierarchy:
This diagram uses the following queries:
SELECT * FROM RCM_DrsInitializationTracking dt
INNER JOIN ReplicationData rg
ON dt.ReplicationGroup = rg.ReplicationGroup
WHERE dt.InitializationStatus NOT IN (6,7)
AND rg.ReplicationPattern=N`Global'
SELECT RequestTrackingGUID, InitializationStatus
FROM RCM_DrsInitializationTracking dt
INNER JOIN ReplicationData rg
ON dt.ReplicationGroup = rg.ReplicationGroup
WHERE dt.InitializationStatus NOT IN (6,7)
AND rg.ReplicationPattern=N`Global'
SELECT RequestTrackingGUID, InitializationStatus
FROM RCM_DrsInitializationTracking dt
WHERE RequestTrackingGUID=@trackingGuid
SELECT Status FROM RCM_InitPackageRequest
WHERE RequestTrackingGUID=@trackGuid