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

ID: Q69327

The information in this article applies to:

Microsoft SQL Server for OS/2, version 4.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 
Issue type        :

Last Reviewed: March 10, 1999