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.




    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 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 of marked transaction specified by the user when the transaction was committed (if any).


    Log sequence number (LSN) of the marked transaction.


    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.