msrepl-backup-lsns-transact-sql.md

title	MSrepl_backup_lsns (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/04/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	replication
ms.topic	language-reference
f1_keywords	MSrepl_backup_lsns_TSQL MSrepl_backup_lsns
dev_langs	TSQL
helpviewer_keywords	MSrepl_backup_Isns system table
ms.assetid	de06c349-82a8-48c6-b602-b5d6938514f6
author	stevestein
ms.author	sstein

MSrepl_backup_lsns (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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.

See Also

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)