There is a server with FoxPro application running on Windows 2003, while some thin clients connect to the server using terminal service and some regular XP workstations connect to the server using LAN connection.
The server is the single point of failure. I like to achieve maximum fault tolerance.
Q#1. Can you recommend some network/hardware architecture to achieve it?
Q#2. Is clustering technology feasible? Any catch behind the cluster technology in terms of database consistency?