About Logical-Log Records

Most SQL statements generate multiple logical-log records. Interpreting logical-log records is more complicated when the database server records the following events in the logical log:

• A transaction that drops a table or index
• A transaction that rolls back
• A checkpoint in which transactions are still active
• A distributed transaction

The following sections discuss the logical-log records for these events.