Restoring a Transaction Log File Backup

When you restore from a transaction log file backup, SQL Server restores changes to the database that are recorded in the transaction log file. You will typically restore transaction log files in order to apply changes that are made to the database since the last full database or differential backup. You can restore transaction log files to restore up to a specific point in time.

You must restore a full database backup before you restore transaction log files. Use the following procedure to restore a transaction log file backup.

To restore a transaction log file backup

1. In SQL Server Enterprise Manager, expand a server group, and then expand a server.
2. Expand Databases, right-click the database you want to restore, point to All Tasks, and then click Restore Database.
3. In the Restore database dialog box, do the following:

   Use this	To do this
   Restore as database	From the drop-down list, select a database name, or type a new name for the restored database.
   Restore	Select Database to restore the database.
   Show backups of database	From the drop-down list, select a database.
   First backup to restore	From the drop-down list, select the most recent transaction log file to restore.

4. Click Point in time restore.
5. In the Point in time Restore dialog box, in the Date box, type the date up to which you want to restore, in the Time box, type the time up to which you want to restore, and then click OK.
6. In the Restore database dialog box, on the Options tab, click Leave database operational. No additional transaction log files can be restored.
7. Click OK to start the restore process.

Copyright © 2005 Microsoft Corporation.
All rights reserved.