logmarkhistory (Transact-SQL)
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
Tasks
Restore a Database to a Marked Transaction (SQL Server Management Studio)
Reference
Concepts
Use Marked Transactions to Recover Related Databases Consistently (Full Recovery Model)