Synchronizing Databases After Defining the Subscription

Synchronize databases after defining the subscription.

1. Dump PDS.pdb. The DSI connection to the replicate database is suspended when the dump marker reaches the replicate Replication Server. It is suspended so that no data will be replicated until you finished step 2. Replication Server activates and validates the subscription automatically when the dump marker is replicated.
   Warning!  Do not execute activate subscription or it will override the wait for dump marker at the Replication Server.
2. Load PDS.primary_pdb to RDS.rdb.
3. Bring RDS.rdb online:
   online database RDS.rdb
4. Prepare RDS.rdb as a replicate:
   1. In RDS.rdb, disable the secondary truncation point, if necessary:

      dbcc settrunc('ltm', 'ignore')

   2. Optionally, disable RepAgent:

      sp_config_rep_agent primary_db, 'disable'

   3. Dump the transaction log.
5. Resume the DSI connection to RDS.rdb.