Restore Transaction Log (General Page)

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.

Tasks

Concepts

Other Resources