How to restore the exchange to a specified point in time using a transaction log copy？

Question

xiaoding133 40

How to use VSS for point in time recovery after using VSS for Exchange transaction log backup?

xiaoding133 40

I didn't find the interface to restore to the specified time in the VSS interface or is there another method?

Accepted answer

1 additional answer

xiaoding133 40 Reputation points

2023-05-18T10:36:18.7333333+00:00

I didn't find the interface to restore to the specified time in the VSS interface or is there another method?

Answer 1

Andy David - MVP 157.4K MVP Volunteer Moderator

You could do this by restoring a full backup and the logs up to the point of time you want to recover.

So you would copy the logs into the directory and also do a full restore. You would have to have the logs available

xiaoding133 40 Reputation points

2023-05-18T11:41:45.8866667+00:00

I have another question,For example, if I did a full backup at 14:00 PM and a log backup at 16:00 PM , how can I replay the logs until 15:30 PM? It is possible that the transaction logs at 15:30 PM in the same file as the transaction logs at 16:00 PM。
xiaoding133 40 Reputation points

2023-05-18T11:44:51.03+00:00

I have another question,For example, if I did a full backup at 14:00 PMand a log backup at 16:00 PM, how can I replay the logs until 15:30 PM? It is possible that the transaction logs at 15:30 PM and 16:00 PM are in the same log file。
Andy David - MVP 157.4K Reputation points MVP Volunteer Moderator

2023-05-18T12:59:36.2266667+00:00

You would have to restore the logs up to the last one created after the desired time. Its not an exact science, but it will capture everything committed to the logs up to that time.

Answer 2

xiaoding133 40

I didn't find the interface to restore to the specified time in the VSS interface or is there another method?