Disabling Secondary Truncation Point in Subscription with Bulk Materialization

Replace the numbered steps in “Subscription with bulk materialization” in Chapter 12, “Managing Replicated Objects Using Multisite Availability.”

  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.pdb to RDS.rdb.
  3. In RDS.rdb, disable the secondary truncation point, if necessary:

    dbcc settrunc('ltm', 'ignore')

  4. Resume the DSI connection to the RDS.rdb.
Parent topic: Replication Server Administration Guide: Volume 1 Documentation Changes