Database Replication Service reinitialization

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 reinitialization (reinit):

Queries

This diagram uses the following queries:

Check if site is in maintenance mode

SELECT * FROM ServerData
WHERE Status = 120

Check that reinit isn't completed for which replication group

SELECT * FROM RCM_DrsInitializationTracking
WHERE InitializationStatus NOT IN (6,7)

Check global data

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'

Check site data

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'Site'

Next steps

• Global data reinit
• Site data reinit
• SQL Server configuration