• Mike Scalise - Wednesday, May 2, 2018 8:05 AM

    RSVC,

    I was reviewing your steps and I had a few more questions if you don't mind.

    1) Steps 2 and 3 are not making sense to me...drop on the secondary and restore on the primary? Wouldn't I want to drop the database where I'm about to restore? In other words, drop database from primary then restore database to primary?

    2) With steps 3 and 4, why would I restore a database on the primary and then back it up right after that? Wouldn't that effectively be the same as the backup I just restored?

    Thanks,

    Mike

    When you remove the Database from the Availability Group there are two copies..
    Server 1 has the copy that you can restore (Step 3). Restore and Overwrite the Database.
    Server 2 ( on Step 2)  will have a database in RECOVERY mode. It will not be accessible. You will remove the DB in the secondary node.

    If you do the above you can then Synchronize again. However, if it tells you that you need to backup the database (Step 4) then you will have to do it (he is trying to make sure you don't get that message but you have a point), otherwise you can synchronize.