• Article

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.