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 shown in Table 5-1:
Column name |
Contents |
---|---|
RepAgent |
|
secondary trunc page |
The first page that is not truncated in the database log |
secondary trunc state |
One of the following values:
|
db rep stat |
A mask constructed of the following:
RepAgent only:
|
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.