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
- How to: Restore a Transaction Log Backup (SQL Server Management Studio)
- How to: Restore a Database to a Marked Transaction (SQL Server Management Studio)
- How to: Restore to a Point in Time (SQL Server Management Studio)
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.
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.
The selected check boxes indicate the backup sets to be restored.
The name of the backup set.
The backed-up component: Database, File, or <blank> (for transaction logs).
The name of the database involved in the backup operation.
The date and time when the backup operation began, presented in the regional setting of the client.
The date and time when the backup operation finished, presented in the regional setting of the client.
The log sequence number of the first transaction in the backup set. Blank for file backups.
The log sequence number of the last transaction in the backup set. Blank for file backups.
The log sequence number of the most recent checkpoint at the time the backup was created.
The log sequence number of the most recent full database backup.
The name of the database-engine instance that performed the backup operation.
The name of the user that performed the backup operation.
The size of the backup set in bytes.
The position of the backup set in the volume.
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.
How to: Restore to a Point in Time (Transact-SQL)
How to: Restore to the Point of Failure (Transact-SQL)
How to: View the Contents of a Backup Tape or File (SQL Server Management Studio)
How to: View the Properties and Contents of a Logical Backup Device (SQL Server Management Studio)
Restoring a Database to a Point Within a Backup
Understanding and Managing Transaction Logs
Working with Transaction Log Backups