Restoring replication after upgrade – Sybase 15.0.2 User Manual

Page 90

Advertising
background image

Post-upgrade tasks

76

Adaptive Server Enterprise

Restoring replication after upgrade

Restore the replication functionality:

1

Log in to 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 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 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 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 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.

Advertising