Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.