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.