Specification for using “Restore to a specific point in time” feature of Veeam Explorer for SQL Server from a backup

[Asahi]

Hi,

WSFC in SQL Server AlwaysOn configuration backed up with Veeam Agent for Windows.
https://helpcenter.veeam.com/docs/backu ... ml?ver=120

WSFC has a 2-node configuration and AlwaysOn is configured so that the transaction log is always backed up from the Secondary node.
https://helpcenter.veeam.com/docs/backu ... ml?ver=120

In fact, if you check the Statistics of the job, the transaction log backup is always taken from the Secondary node.

In that state, I selected the Primary node backup from the Veeam console and opened Veeam Explorer for SQL Server.
Then, from “Restore to a specific point in time”, you can select any transaction point using the slider.
https://helpcenter.veeam.com/docs/backu ... ml?ver=120

Is it possible to open Veeam Explorer for SQL Server from a backup file on the Primary node and do a point-in-time restore even though the transaction log is always backed up from the Secondary node, because the “Failover Cluster” type is selected in the backup job settings?
https://helpcenter.veeam.com/docs/backu ... ml?ver=120
https://helpcenter.veeam.com/docs/backu ... ml?ver=120

I thought “Restore to a specific point in time” was only available from the node from which the transaction log backup was taken.

Kind Regards,
Asahi,
Climb Inc.

[PetrM]

Hello,

The point-in-time restore is possible from any cluster node, regardless of which node was a source of the t-log backup.

Thanks!

[Asahi]

Hi Petrm,

Thank you for the clear answer!

Kind Regards,
Asahi