Installation guide

10.7.4.2 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.

Procedure

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.

Installation Guide for Linux

SAP ASE Upgrades