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?
