Freeing of logical-log files

Each time the database server commits or rolls back a transaction, it attempts to free the logical-log file in which the transaction began. The following criteria must be satisfied before the database server frees a logical-log file for reuse:
  • The log file is backed up.
  • No records within the logical-log file are associated with open transactions.
  • The logical-log file does not contain the oldest update not yet flushed to disk.