Verifying the State of the Secondary Truncation Point
Check whether the secondary truncation point is set for
a database.
Log in to the primary database.
Execute dbcc gettrunc.
For
example, to see if the secondary truncation point is set in the Parts database:
> use Parts
> go
> dbcc gettrunc
> go
In the output, a 0 in
the ltm_trunc_state column means
the secondary truncation point is turned off for the database. A 1 in the ltm_trunc_state column
indicates the secondary truncation point is turned on.