February 8, 2022 at 11:12 am
HI,
SQL Alwasyon setup configuration completed and works fine as expected with 2 nodes windows cluster multi subnet and SQL listener configured multiple IPs. and quorum fail share witness configured remote site. please suggest as below scenario
Primary Availability group to changed to Manual failover mode instead of automatic failover. in this setup how do we make it read/write mode in secondary replica if primary replica totally down? due to manual failover database does not automatically switchover to secondary.
Thanks
February 8, 2022 at 4:51 pm
In a manual failover, ASYNC mode, you execute
ALTER AVAILABILITY GROUP <AGNAME> FORCE_FAILOVER_ALLOW_DATA_LOSS
In a manual failover, SYNC mode, you execute
ALTER AVAILABILITY GROUP <AGNAME> FAILOVER
February 9, 2022 at 5:42 am
Thank you Ant-Green for your reply.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply