Redundant Servers for Branch Locations

[AKPolarBear]

We are in the middle of suffering through a major fiber cut that has disabled one of our branch locations ability to connect to the servers located here at the main office. They also lost their phones lines which was part of our initial backup plan years ago but was later dropped due to technical issues. It would not have helped us now and we do not have secondary service available either.

So, while we wait for the 4800 fibers to be re-spliced, I was wondering if it is possible to locate a server in the branch locations that could operate locally during this type of problem or other similar situations. I do not know of any method Macola can offer to allow the servers to update each other once they are reconnected. So this means that all the data would have to be reentered, which we have to do now anyway. The only real advantage is we can continue to look like we are still in business, print orders, check prices, etc. to our customers.

I am thinking that others have faced this problem and may have found a workable solution. We do not use PC's and are Citrix based.

We could try and hook a laptop up to a cell phone and connect that way via the Citrix client, but I perceive that to be problematic with that type of connection.

 

[kscheeler]

You can't do replication in SQL server because the Macola tables are not defined with primary keys but rather with clustered indexes. SQL requires primary keys on tables to use replication.

You could put a server and citrix server at the disconnected site and run Macola locally. I would have the main office or connected offices enter all of the necessary information for the disconnected office and then "push" a copy of the database(s) to them most likely once a day. In your current case, you would probably overnite a copy to them every day.

Kevin Scheeler