Disabling the secondary truncation point

When you upgrade a primary database, the Rep Agent , the Log Transfer Agent or Replicator must not be running, and you should turn off the secondary truncation point for the duration of the upgrade. The Rep Agent or Log Transfer Manager should already be shut down (from the previous steps).

For each primary database and replicated RSSD, disable the secondary truncation point:

1. If this is a replicated RSSD, log in to the Replication Server of the RSSD and issue:

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

2. Disable the secondary truncation point in the Adaptive Server database that is being upgraded by issuing:

   1> use database
   2> go
   

   1> dbcc settrunc('ltm', 'ignore')
   2> go
   

   If the dbcc settrunc command fails, make sure that the Rep Agent or LTM are not running. When the Rep Agent and LTM are disabled, repeat this step.

3. Truncate the primary transaction log running the command:

   1>dump tran primary_dbname with truncate_only
   2>go
   

4. Zero out the Replication truncation point as soon as you can stop Replication Server. In the RSSD for the Replication Server, run:

   1>rs_zeroltm primary_servername, primary_dbname
   2>go