Verifying the State of the Secondary Truncation Point

Check whether the secondary truncation point is set for a database.

1. Log in to the primary database.
2. 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.