I'm a bit of a novice when it comes to AlwaysOn, so I was hoping some of you that have expertise in this area can help me understand the high-level process for restoring a database to an AOAG cluster. Is it simply:
1) Disable AOAG
2) Delete the database from the primary
3) Restore database to primary
4) Restore database to secondary (and others if necessary)
5) Enable AOAG
Something like that? Also, would your answer change if this were a true production cluster vs a non-production one (where HA isn't critical).
Thank you in advance.
Mike
First please specify is the database to be restored currently a member of the existing AG?
In this particular scenario, the database to be restored is NOT currently a member of the existing AG...
Ok so why do you think you need to disable the AG, which incidentally you cannot do.
Correct sequence is
1) Restore backup of the new database to the Primary replica
2) either manually or using wizard, stage the secondary databases
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉