Restoring replication after upgrade

Restore the replication functionality:

  1. Log into the RSSD for each replicated primary, and for each replicated RSSD, and issue:

    1> use RSSD_name
    2> go
    
    1> rs_zeroltm dataserver, database
    2> go
    
  2. Log into each replicated primary, and replicated RSSD and issue:

    1> use database
    2> go
    
    1> dbcc settrunc ('ltm', 'valid')
    2> go
    
  3. Restart the Replication Server.

  4. If the database is also used as a RSSD, resume the Replication Server connection to the RSSD by issuing the following command to the Replication Server:

    1> sysadmin hibernate_off, 'Replication Server'
    2> go
    

    Make sure to specify the same string that was specified during the 'hibernate_on' command.

  5. Log into the Replication Server, and resume the Log Transfer connection for each replicated primary and each replicated RSSD:

    1> resume log transfer from server.database
    2> go
    

    If this is a replicated RSSD, you will need to log into the replicate Replication Server.

  6. If you are using Rep Agent, log into the Adaptive Server and restart the Rep Agent:

    1> use database
    2> go
    
    1> sp_start_rep_agent database
    2> go
    
  7. If you are using LTM, restart the LTM.