1

I understand that SQL AG supports the automatic page repair when the primary is synchronized with the secondary.

Suppose the AG is configured in an async commit mode, then does also mean that the primary and secondary are synchronized (I know there would be a delay), there by providing for automatic page repair?

1 Answer 1

0

The replica must be SYNCHRONIZED and in a healthy state for the primary to attempt page repair.

Below is what MSDocs says on the topic.

On the principal/primary database, automatic page repair is tried only when the database is in the SYNCHRONIZED state and the principal/primary is still sending log records for the database to the mirror/secondary.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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