How to apply a transaction log backup (Enterprise Manager)
Note If you are restoring a transaction log backup that does not have any backup set information listed in the backup history stored in the msdb database, such as a transaction log backup created on another server, see How to restore a backup from a backup device.
To apply a transaction log backup
- Expand a server group, and then expand a server.
- Expand Databases, right-click the database, point to All Tasks, and then click Restore Database.
- In the Restore as database box, type or select the name of the database to restore, if different from the default.
- Click Database.
- In the First backup to restore list, click the backup set to restore.
- In the Restore list, click the transaction log backup to restore.
- Optionally, click the Options tab and , and then do one of the following:
- Click Leave database operational. No additional transaction logs can be restored if no further transaction log or differential database backups are to be applied.
- Click Leave database nonoperational, but able to restore additional transaction logs if another transaction log or differential database backup is to be applied.
- Click Leave database operational. No additional transaction logs can be restored if no further transaction log or differential database backups are to be applied.