0

We are planning to turn off the secondary synchronous replica in our always on availability group for few hours for maintenance . Once we are done with the maintenance then we will need to failover and do maintenance on the original primary node.

Here is my question for example during the maintenance if there were around 5 gigs of log files that were not applied when we took the secondary node off , now when the secondary comes back online can we immediately failover and make the secondary the new primary or we will have to wait for the logs to be applied to the secondary first to make it synchronized and then failover to make it the new primary.

2

After the secondary replica comes back online, it will not immediately be available for fail over.

You will need to wait for the 5GB of logs to send to secondary and be redone. During which time Primary will have generated more logs that will need to sync and be redone. Once all logs are synched, you'll be able to fail over to secondary without incurring data loss.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.