Domain Model

[Graeme]

Imagine:<br>
<br>
350 locations each having up to 120 NT workstations all running SQL to a SQL server on site (Stand Alone).<br>
<br>
2 Main HQ Locations<br>
<br>
Based on a master Domain model would it be resourceful to have all 350 locations with PDC & BDC's. Forgot to mention the 350 locations are spread into geographical regions and are referred to in their own domain, which has the interaction with the master. The 350 locations need to be self sufficient if all hell breaks loose and the WAN dissapears. <br>
<br>
I know that is sketchy but imagine it as an MCSE question<br>
<br>
Q: Plan the domain model based on the above info<br>
<br>
Any idea's will be greatly appreciated. The system is up and running at the moment but I don't think it is resilient and fraught with disaster.<br>

 

[AMA]

Should we assume that all the remote sites need to access the sql data bases of one another. And if the WAN gose down all the sites will be unable to function properly. In that case the real question is how to access the 350 SQL sites. I can think of 2 soultions. 1. Develop a method of sycronizing the databases so each site will eventually have a complete or nearly complete data base. 2. Have one Master list in a centalized location where incase of an outage the sites could dial into or access a web site to get all the information.