Show TOC

dbcc gettruncLocate this document in the navigation structure

A Transact-SQL command to retrieve current RepAgent information about an Adaptive Server database.

dbcc gettrunc
  • Use dbcc gettrunc for RepAgent-enabled databases.

  • The dbcc gettrunc command returns a single row containing the columns as shown:

    Table 1: Columns Returned by dbcc gettrunc

    Column Name



    secondary trunc page

    The first page that is not truncated in the database log

    secondary trunc state

    One of these values:

    • 1 – Adaptive Server does not truncate the log on or after the truncation page

    • 0 – Adaptive Server ignores the truncation page

    db rep stat

    A mask constructed of the following:

    • 0x01 – Secondary truncation page is valid

    • 0x02 – Database contains at least one explicitly replicated table

    • 0x04 – Database contains replicated stored procedures

    • 0x08 – Replicate all to standby database

    • 0x10 – Replicate L1 to standby database

    • 0x80 – Replication Agent automatically restarts after an HA failover

    RepAgent only:

    • 0x20 – RepAgent enabled

    • 0x40 – Autostart RepAgent

    generation id

    The database generation ID

    database id

    The Adaptive Server ID number of the database

    database name

    The name of the database

    ltl version

    RepAgent: The log transfer language (LTL) version


There is no difference in replicating L1 and all to standby database because to date, only support level L1 has been implemented in Adaptive Server version 12.0 and later. For more information, see sp_reptostandby.