Turning Off the Secondary Truncation Point in a Database

Disable the secondary truncation point for a database to truncate portions of the log that have not been transferred. Truncating the log frees only the log pages that the RepAgent has sent to the Replication Server with confirmation.

Note: Only the Adaptive Server system administrator and the database owner have permission to execute the dbcc settrunc command.

Suspend the RepAgent that is forwarding the log.

Otherwise, executing dbcc settrunc results in the following error:

The log transfer context for the current database is
already reserved by Adaptive Server process 7. The log
transfer context for the current database is not
reserved.

Log in to the Adaptive Server that contains the database for which to turn off the secondary truncation point.
Execute dbcc settrunc(ltm, ignore) to turn off the secondary truncation point.
To turn off the secondary truncation point in the database named Parts:
```
> use Parts
> go
> dbcc settrunc(ltm, ignore)
> go
```
Truncate the log using the Transact-SQL dump transaction command. See Adaptive Server Enterprise Reference Manual.
Dump the transaction log.
This may result in the loss of updates to the replicate database. The primary database is not affected. You must reapply the lost updates to the replicate database. See Replication Server Administration Guide Volume 2.