Please do help us with this critical issue.
We have 2 node DAG, one of the MB server has issues on the physical host itself and keeps hanging. All the databases has copies on 2 MB servers. But when this MB2 server gets hanged the database shows dismounted. It doesn't switch over to MB1 which should be happening. We have to restart the MB2 to get the database up and running or wait for long time to move to MB1.
We currently have plans to built another node and gradually remove the faulty MB2.
Please instruct us on how to prevent the current databases which is on MB1 not to move to MB2 and stay in MB1 itself
Awaiting kind response on this regard
Thanks in Advance
-Sanjai