Setting the secondary truncation point

Before you restart a RepAgent, you need to reestablish the secondary truncation point using dbcc settrunc(ltm,valid). For example, to reestablish the secondary truncation point in the Parts database, log in to the Adaptive Server with the database and execute:

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

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.

After resetting the locater for the database in the rs_locater table, resume the Replication Server to restart the RepAgent. The RepAgent begins scanning the log from the page returned in the ltm_truncpage column by the dbcc gettrunc command.