Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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
Reference
Other Resources
How to: Restore a Database to a Marked Transaction (SQL Server Management Studio)
Using Marked Transactions (Full Recovery Model)