always on sync to the secondary replica

Question

hi folks,

how do i sync up secondary replica in always on with the primary replica if my primary is online and i can not take primary offline.

I'm thinking of approach,

-backup full db on primary and restore it on to secondary with norecovery

-backup tran. log on primary and restore it on to secondary with norecovery

-Add database to always on group with "join only" option.

Is this approach correct. In this approach my question is :

What happens to all the transactions on primary after the last transaction log backup is taken and restored to secondary. Will AG automatically sync all the remaining pending transactions to secondary that happened after last restore of the transaction log backup?

Answer 1

Hi @Heisenberg,

Please refer to this document to know Differences between availability modes for an Always On availability group

You can find the answer in this link.

If you choose Join only;

It means you need to manually take full backup and log backup of each database we selected and transfer it to the secondary server before passing this step.

Best regards,

Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".