I have started building out a HA ZCM solution with two Primary Servers and two MS SQL servers configured for redundancy.

I'm not planning on a L4 switch and read somewhere that you can configure closest server rules to make your agents talk to the second primary server if the first one goes down. I just cannot seem to find where I read it from. Also previously in this forum It was suggested to me to run MS SQL in HA mode, but I never got what file to edit if I needed to point to the second MS SQL server (This would be more DR than HA).

Is there a document that explains how to build a HA ZCM solution that someone could point me to?