Setting the Secondary Truncation Point

Reestablish the secondary truncation before restarting a RepAgent.

1. Log in to the Adaptive Server that contains the database whose secondary truncation point you want to reestablish.
2. Execute dbcc settrunc(ltm,valid) to reestablish the secondary truncation point. For example, to reestablish the secondary truncation point in the Parts database:

   > use Parts
   > go
   > dbcc settrunc(ltm, valid)
   > go

3. Use the dbcc gettrunc command to verify that the secondary truncation point has been enabled:

   > use Parts
   > go
   > dbcc gettrunc
   > go

   The ltm_trunc_state column in the output from this command should contain a 1.

4. Reset the locater for the database in the rs_locater table.
5. Resume the Replication Server to restart the RepAgent.