• Mike Scalise - Tuesday, May 1, 2018 9:41 AM

    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?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉