Restoring from SQL transaction logs up to a point in time

You can restore transactions from a transaction log up to and including a point in time in the transaction log. After the point in time is reached, recovery from the transaction log is stopped. To find dates and times of transactions, check your client application event log.

If the specified point in time is later than the time contained in the most recent transaction log being restored, then the restore operation succeeds, but a warning is generated and the database remains in an intermediate state. If the specified point in time is before the time contained in the transaction log or logs being restored, no transactions are restored.

To restore from SQL transaction logs up to a point in time

  1. On the navigation bar, click the arrow next to Restore.

  2. Click New Restore Job.

  3. On the Properties pane, under Source, click Selections.

  4. 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.

  5. On the Properties pane, under Settings, click Microsoft SQL.

  6. On the Restore Job Properties dialog box, click Leave the database ready to use; additional transaction logs or differential backups cannot be restored.

  7. Select Point in time log restore, and then select a date and time.

  8. Start the restore job or select other restore options from the Properties pane.

More Information

Setting restore options for SQL

Restoring data by setting job properties

About restoring SQL databases and file groups

Restoring from SQL 2000, SQL 2005 or SQL 2008 transaction logs up to a named transaction