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:-
Launch SQL management studio and connect to the relevant database instance
Expand databases
Right-click relevant database (e.g. ORC_LIVE) and select Tasks
Select restore, database
Click Timeline
Click Specific date and time
Enter relevant date and time
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.