Obtain a datra dump from a trusted source and apply the dump to the target database you want to resynchronize.
- Stop replication processing by suspending
Replication Agent.
- Place Replication Server in resync mode.
In resync
mode, Replication Server skips transactions and purges replication
data from replication queues in anticipation of the replicate database
being repopulated from a dump taken from the primary database or
trusted source.
- Restart Replication Agent and send a resync database
marker to Replication Server to indicate that a resynchronization
effort is in progress.
- Obtain a dump from the primary database.
When Replication Server detects a dump marker
that indicates completion of the primary database dump, Replication
Server stops skipping transactions and can determine which transactions
to apply to the replicate database.
- Apply the dump to the replicate database.
- Resume replication.