Disabling the secondary truncation point

At this point, all the information contained on the primary logs has been processed, transfered to their destinations and the RepAgent or other applications used for replicateion has been shut down. The Rep Agent or other replication application must be shutdown, and the secondary truncation point should be disabled.

If the RSSD is being upgraded, you must stop the Replication Server at this point. For each primary database, 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. The Replication truncation point must be zeroed out. The Replication Server must be shutdown before performing this operation:

   Using the RSSD for the Replication Server, run:

   1>rs_zeroltm primary_servername, primary dbname
   2>go