Редагувати

Поділитися через


logmarkhistory (Transact-SQL)

Applies to: SQL Server

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)