Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I have forced manual failover AOAGs to BCP node.I tested my application and data is reflecting in tables very late.Is it expected behavior or I need to take care of anything permissions,firewall ports etc...
One more thing,
After forced failover I bought the databases online by resume data movement but Replicas shows still in ? mode.How can I make them Online.
Please advice.
Latency on the asynchronous replica will be dependent on lots of factors, such as size of the transactions (index rebuilds could cause a huge amount of backlog), I/O, network, etc. If you want zero latency, then you'll need to use synchronous and not asynchronous, but be aware that this adds to the transaction time and should be within the same data center as the primary replica (in general).
When you force failover, the AG replicas will need to be rebuilt with a full backup and log chain to get back in sync and rejoined to the AG.
