• Article

Restore Transaction Log (General Page)

Use this page to specify information about the target and source databases for a transaction-log restore operation.

To restore a transaction log by using SQL Server Management Studio

Note

When you specify a restore task by using SQL Server Management Studio, you can generate the corresponding Transact-SQL RESTORE script by clicking the Script button and then selecting a destination for the script.

Options

  • Database
    Select the name of a database that is in the restoring state. The list includes all databases on the server, excluding the system databases master and tempdb.

  • From previous backups of database
    Select the name of the database whose log backups you want to restore. This information comes from what is stored in the backup history in the msdb database on the server. If the history has been deleted, or you are restoring to a different server, you must use the File or Tape option.

  • From file or tape
    Click the Browse (...) button to select one or more files or tapes as the source for the transaction log backup or backups.

  • Select the transaction log backups to restore
    Displays a grid that lists the transaction log backups available for the selected database. A log backup is available only if its First LSN is greater than the Last LSN of the database. Log backups are listed in the order of the log sequence numbers (LSNs) they contain, and they must be restored in this order.

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

    Header

    Values

    Restore

    The selected check boxes indicate the backup sets to be restored.

    Name

    The name of the backup set.

    Component

    The backed-up component: Database, File, or <blank> (for transaction logs).

    Database

    The name of the database involved in the backup operation.

    Start Date

    The date and time when the backup operation began, presented in the regional setting of the client.

    Finish Date

    The date and time when the backup operation finished, presented in the regional setting of the client.

    First LSN

    The log sequence number of the first transaction in the backup set. Blank for file backups.

    Last LSN

    The log sequence number of the last transaction in the backup set. Blank for file backups.

    Checkpoint LSN

    The log sequence number of the most recent checkpoint at the time the backup was created.

    Full LSN

    The log sequence number of the most recent full database backup.

    Server

    The name of the database-engine instance that performed the backup operation.

    User Name

    The name of the user that performed the backup operation.

    Size

    The size of the backup set in bytes.

    Position

    The position of the backup set in the volume.

    Expiration

    The date and time the backup set expires.

  • Point in time
    Restore the database to the most recent time available in the backups or to a particular point in time. The default is Most recent possible. To specify a specific point in time, click the Browse (...) button.

    The date and time are indicated in the regional setting of the client.

  • Marked transaction
    Restore the database to a previously marked transaction. Selecting this option opens the Select Marked Transaction dialog box.