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.