Restoring replication after upgrade

  1. Zero out the locator in the RSSD for each replicated primary.

    Using isql, connect to the RSSD and execute:

    1> use RSSD 
    2> go 
    1> rs_zeroltm dataserver, RSSD 
    2> go
    
  2. Set the secondary truncation point to “valid” in each primary database. Using isql, connect to the replicated primary database, and execute:

    1> use database
    2> go
    1> dump tran database with truncate_only
    2> go
    1> dbcc settrunc("ltm","valid")
    2> go