INF: Dump Point Flag in the Transaction Log of SQL Server

Last reviewed: April 25, 1997
Article ID: Q69327

The information in this article applies to:

  - Microsoft SQL Server version 4.2 for 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

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 query words: Dumping loading
Keywords : kbother SSrvServer
Version : 4.2
Platform : OS/2

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 25, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.