Comprehensive data protection for all workloads
Post Reply
ScottE
Lurker
Posts: 1
Liked: never
Joined: Sep 27, 2022 12:05 pm
Contact:

Restore Node in SQL Always On Group

Post by ScottE »

Is there a tech document on restoring an entire node of a SQL Always On group? Are we able to perform a complete restore or only the OS drives and then need to resync the databases from the active nodes? Do we remove the failed node from the Always on Group at some point or not? Step by step instructions would be great.

Thank you!
PetrM
Veeam Software
Posts: 3626
Liked: 608 times
Joined: Aug 28, 2013 8:23 am
Full Name: Petr Makarov
Location: Prague, Czech Republic
Contact:

Re: Restore Node in SQL Always On Group

Post by PetrM »

Hello,

There is no such document but in the vast majority of cases, we expect that all nodes will be synchronized automatically because data replication in Always On is running permanently. You may have a look at this thread. The volume-level restore does nothing with an application and if some databases are in "Recovery Pending" or "Not synchronized" states, it will be up to DBA to put everything in order. Also, you have an option to restore databases using Veeam Explorer for SQL.

Thanks!
Post Reply

Who is online

Users browsing this forum: No registered users and 43 guests