Restoring Replication on Primary Databases

Restore replication if you have upgraded a source database, or primary database, in a Replication Server system, or if the destination database is also a source for other Replication Servers.

  1. If you have zeroed out the locator for the database, go to the next step. Otherwise, stop Replication Server, then run:
    1> use RSSD_name
    2> go
    1> rs_zeroltm dataserver, database
    2> go
  2. Log in to 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 an RSSD, resume the Replication Server connection to the RSSD by issuing the following command to the Replication Server specifying the same string that was specified during the hibernate_on command:
    1> sysadmin hibernate_off, 'Replication Server'
    2> go
  5. Log in to 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 must log in to the replicate Replication Server.
  6. If you are using Rep Agent, log in to the SAP ASE server and restart the Rep Agent:
    1> use database
    2> go
    1> sp_start_rep_agent database
    2> go
  7. If you are using the Log Transaction Manager, restart it.