INFO: Dump Point Flag in the Transaction Log of SQL Server (69327)
The information in this article applies to:
- Microsoft SQL Server 4.2x
This article was previously published under Q69327 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
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.
Modification Type: | Minor | Last Reviewed: | 2/14/2005 |
---|
Keywords: | kbinfo kbother KB69327 |
---|
|