Share via

How to: Restore a Database to a Marked Transaction (SQL Server Management Studio)

  • Article

When a database is in the restoring state, you can use the Restore Transaction Log dialog box to restore the database to a marked transaction in the available log backups.

To restore a marked transaction

  1. After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.

  2. Expand Databases, and, depending on the database, either select a user database or expand System Databases and select a system database.

  3. Right-click the database, point to Tasks, and then click Restore.

  4. Click Transaction Log, which opens the Restore Transaction Log dialog box.

  5. On the General page, in the Restore To section, select Marked transaction, which opens the Select Marked Transaction dialog box. This dialog box displays a grid listing the marked transactions available in the selected transaction log backups.

    By default, the restore is up to, but excluding, the marked transaction. To restore the marked transaction also, select Include marked transaction.

    The following table lists the column headers of the grid and describes their values.

    Header Value

    <blank>

    Displays a checkbox 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 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.

See Also

Tasks

How to: Restore a Database Backup (SQL Server Management Studio)
How to: Restore a Transaction Log Backup (SQL Server Management Studio)

Other Resources

SQL Server Management Studio Tutorial

Help and Information

Getting SQL Server 2005 Assistance