logmarkhistory (Transact-SQL)


Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure 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 nameData typeDescription
database_namenvarchar(128)Local database where marked transaction occurred.
mark_namenvarchar(128)User-provided name for marked transaction.
descriptionnvarchar(255)User-provided description of the marked transaction. Can be NULL.
user_namenvarchar(128)Database user name that performed marked transaction. Can be NULL.
lsnnumeric(25,0)Log sequence number of transaction record where mark occurred.
mark_timedatetimeCommit time of marked transaction (local time).

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)

Community Additions