Restoring Replication

Restore replication after you perform the upgrade procedure.

  1. Zero out the locator in the RSSD for each replicated primary.
    Use isql to connect to the RSSD and execute:
    use RSSD
    go
    rs_zeroltm dataserver, database_name
    
    go
  2. Set the secondary truncation point to “valid” in each primary database. Use isql to connect to the replicated primary database and execute:
    use database
    go
    dump tran database with truncate_only
    go
    dbcc settrunc("ltm","valid")
    go