MSrepl_backup_lsns

Transact-SQL Reference

Transact-SQL Reference

MSrepl_backup_lsns

The MSrepl_backup_lsns table contains transaction log sequence numbers (lsn) for supprting the 'sync with backup' option of the Distribution database. This table is stored in the distribution database.

Column name Data type Description
publisher_database_id int ID of the Publisher database.
valid_xact_id varbinary(16) ID of the transaction to be sent to the Publisher to mark the log truncation point. Used only if the Distribution database is in 'sync with backup' mode. Contains the ID of the latest replicated transaction in the Distribution database that has been backed up. It will be sent to the Publisher to mark the log truncation point by the Log Reader.
valid_xact_seqno varbinary(16) Sequence number of the transaction to be sent to the Publisher to mark the log truncation point. Used only if the Distribution database is in 'sync with backup' mode. It is the log sequence number of the latest replication transaction in the Distribution database that has been backed up. It will be sent to the Publisher to mark the log truncation point by the Log Reader.
next_xact_id varbinary(16) Temporary log sequence number used by backup operations.
nextx_xact_seqno varbinary(16) Temporary log sequence number used by backup operations.