logmarkhistory-transact-sql.md

title	logmarkhistory (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	logmarkhistory logmarkhistory_TSQL
dev_langs	TSQL
helpviewer_keywords	logmarkhistory system table
ms.assetid	5c1becc5-f34e-4869-bf69-dfafab684540
author	stevestein
ms.author	sstein

logmarkhistory (Transact-SQL)

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

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)