MOSS 2007 – High Availability scenario.

Site A and Site B are 1500 miles apart with a ~10mb pipe between the 2.

SQL Mirror exists on the back end. If the mirror at Site A becomes the mirror,(Principal becomes the mirror) and site B becomes the Principal, what configuration changes must be made for the WFEs to not lose connection to the DBs?

Site A:
MOSS Primary WFE
SQL Principal DB

Site B:
MOSS Secondary WFE in Farm.
SQL Mirror DB

Ultimately, can this be automated?

If it can NOT be automated, what is exactly required to make the WFEs in all locations synch up (all services) to the “new” (now principal) DB server. Can it be scripted to expedite the process?