Select Marked Transaction
Use the Select Marked Transaction dialog box to select a marked transaction when restoring a transaction log. For information about how to use marked transactions for backup and restore, see Using Marked Transactions (Full Recovery Model).
To restore to a marked transaction by using SQL Server Management Studio
Options
Select the marked transaction to stop the restore at
Displays a grid listing the marked transactions available in the selected transaction log backup or backups. The following table lists the column headings of the grid and describes their values.Header
Values
<blank>
Displays a check box for selecting the mark.
Transaction Mark
Name of the marked transaction specified by the user when the transaction was committed.
Date
Date and time of the transaction when it was committed. Transaction date and time are displayed as recorded in the msdb gmarkhistory table, not in the client computer's date and time.
Description
Description of marked transaction specified by the user when the transaction was committed (if any).
LSN
Log sequence number (LSN) of the marked transaction.
Database
Name of the database where the marked transaction was committed.
User Name
Name of the database user who committed the marked transaction.
Include marked transaction
Includes the selected marked transaction. If this option is selected, the log is restored up to and including the marked transaction. If the option is not selected, it is restored up to, but not including, the marked transaction.
See Also