Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayMSrepl_backup_lsns (Transact-SQL)
Applies to: 
SQL Server
The MSrepl_backup_lsns table contains transaction log sequence numbers (LSN) for supporting 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 | The ID of the Publisher database. |
| valid_xact_id | varbinary(16) | The 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) | The Sequence number of the transaction to be sent to the Publisher to mark the log truncation point. This is 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) | The temporary log sequence number used by backup operations. |
| nextx_xact_seqno | varbinary(16) | The temporary log sequence number used by backup operations. |
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)