Microsoft KB Archive/69327

= INFO: Dump Point Flag in the Transaction Log of SQL Server =

Article ID: 69327

Article Last Modified on 2/14/2005

-

APPLIES TO


 * Microsoft SQL Server 4.21a Standard Edition

-



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 &quot;dump point.&quot; This dump point is used by the dump transaction process to determine which transactions are dumped and removed from the transaction log.

Additional query words: Dumping loading

Keywords: kbinfo kbother KB69327

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.