Hi All
Scenario: Always on server with two nodes. Litespeed takes care of the backups always on the regardless which Node is the active. SO we can end up with backups coming from any node on a specific folder.
##############################
QUESTION: Is it possible to restore a database where full ,diff and tlogs backups are from any of the nodes? Is it possible to do that manually in LiteSpeed?
ANSWER: It’s possible depending on the state of synchronization between the primary and secondary databases.
QUESTION: Is it possible to automate this restore with Automated restore?
ANSWER: No, as the backups come from two different SQL instances.
##############################
A little bit disappointed that in one way it is supported and in other not.
At the moment I have a script that it does it but is a manual process (it queries the server and take all the backups regardless the node and provide me syntax to restore all of them).
Anyway it would be nice to have this feature directly form the console..
Best regards
