logmarkhistory (Transact-SQL)

APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

Contains one row for each marked transaction that has been committed. This table is stored in the msdb database.

Column name Data type Description
database_name nvarchar(128) Local database where marked transaction occurred.
mark_name nvarchar(128) User-provided name for marked transaction.
description nvarchar(255) User-provided description of the marked transaction. Can be NULL.
user_name nvarchar(128) Database user name that performed marked transaction. Can be NULL.
lsn numeric(25,0) Log sequence number of transaction record where mark occurred.
mark_time datetime Commit time of marked transaction (local time).

See Also

Restore a Database to a Marked Transaction (SQL Server Management Studio)
Use Marked Transactions to Recover Related Databases Consistently (Full Recovery Model)
System Tables (Transact-SQL)