The following procedure provides details on how to restore transactions from a transaction log up to and including a point in time in the transaction log.
See How to restore from SQL transaction logs up to a point in time.
To restore from SQL transaction logs up to a point in time
-
In the restore selections list, select the most recent full database backup set, and the most recent differential database backup set, if any, and all the log backup sets you want to restore.
-
On the Properties pane, under Settings, click Microsoft SQL.
-
On the Restore Job Properties dialog box, click Leave the database ready to use; additional transaction logs or differential backups cannot be restored.
-
Select Point in time log restore, and then select a date and time.
-
Start the restore job or select other restore options from the Properties pane.
More Information
Restoring data by setting job properties
About restoring SQL databases and file groups
Restoring from SQL transaction logs up to a named transaction