Export (0) Print
Expand All

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

NoteNote

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.

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.

Community Additions

ADD
Show:
© 2014 Microsoft