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
Look, if the database is fine on the Primary node all you have to do is just add it to the Availability Group.
The wizard will let you know if it needs a Recovery model or a backup or both. Once it meets the prerequisites then everything should work.
If the AOAG is functioning properly.