We have 4 locations with 4 servers, one per office each hosting a copy of our DB file.
We initially wanted one server where we could host all the files since that would simplify many things. This would be accesed by th remote locations via a site to site vpn for security.
The problem we encountered is that 2 of the 4 locations only have the option for att as an ISP and the service is not good at all, we loose internet at least once a week and on one specific instance we went withoug internet for 4 days.
I was thinking that we could host the file at one location and have all locations working from that file however would like to periodically update the records from all tables to local server in each location to have an exact copy at each location in the event the internet goes down the employees would just switch to the local copy.
Does anyone have an idea of how this would be possible if at all?