Filter
Top Products
CHAPTER 5 Upgrading Adaptive Server
Installation Guide 73
Reenabling Replication Server
If you disabled replication before the upgrade, you must reenable replication.
To do so, first remove any older format log records from your database, and
then reenable replication.
Removing old log records
Use the dump tran command to dump the database and transaction logs to
remove the older format log records from your database. This prevents
Replication Server from accessing the pre-upgrade portion of the transaction
logs.
For example, to dump the
sales database:
1> use master
2> go
1> dump database sales to dumpdev
2> go
Reenabling replication
Follow the steps in this section to reenable replication after upgrading the
primary databases and primary RSSDs.
For each primary database and RSSD:
1 Start Adaptive Server if it is not already running.
2 Log in to the server.
3 Clear the locator for the database by executing the following command in
the RSSD for this database:
1> use RSSD
2> go
3> rs_zeroltm dataserver, database
4> go
4 Enable the truncation point for the database.
1> use database
2> go
1> dbcc settrunc("ltm", "valid")
2> go
5 Restart the Replication Servers and LTMs.