ID Number: Q69327
1.10 1.11 4.20
OS/2
Summary:
When a transaction log dump is made, the next dump of the log does not
include all the information contained in this dump because SQL Server
flags the portion of the log as having been backed up.
More Information:
Page 141 of the SQL Server version 1.1 "Microsoft SQL Server System
Administrator's Guide" states that when restoring a database and
transaction logs, the transaction log dumps must be restored in the
order in which they were made.
SQL Server flags the portion of the transaction log once it has been
backed up. In other words, if the transaction log was never truncated,
the transaction log dumps include everything from before the previous
transaction log dumps. The dump transaction process performs a
checkpoint on the database to flush all completed transactions to
disk. This point in the transaction log is marked as the "dump point."
This dump point is used by the dump transaction process to determine
which transactions are dumped and removed from the transaction log.
Additional reference words: Dumping loading 1.10 1.11 4.20