Skip to main content

How to restore database from previous date and time

Written by Charnjit Singh Dharival

How to revert the database to a specific point in time e.g. 20:00 31st May 2023.


If you are using a on premise server, please ask your IT department to complete the following steps:-

  1. Launch SQL management studio and connect to the relevant database instance

  2. Expand databases

  3. Right-click relevant database (e.g. ORC_LIVE) and select Tasks

  4. Select restore, database

  5. Click Timeline

  6. Click Specific date and time

  7. Enter relevant date and time

  8. Click OK


Note: Within the timeline interval graph, Transaction log backup is in green and full database backup period is in dark green.

If you are hosted, we can action this for you. Please raise a new case online referencing the title of this article and a member of our support team will be able to help you further.

Did this answer your question?