I have two Windows Server 2003 systems:
I have a very busy dental office running a critical application. If this application does not work, the office shuts down. I recently migrated to a brand new Dell server with RAID5, dual CPUs. This new system recently lost the motherboard, creating a lot of agony between me and the nine dentist/hygienists.
My plan is to beef up the old machine with RAID, more memory, etc., and use this system as a "hot" standby. In order to have a hot standby, I need a method to replicate files to the hot standby system.
This dental application contains about 35GB in database files (Sybase Adaptive Server). I am looking for a "robust" method to keep the data on the old machine in sync with the on-line data server so if I lose the main on-line server, I could switch back to the older system by pointing the client workstations to standby servername.
I am looking for advice on what software is available to replicate on a near real-time basis all the new, updated or deleted files from the on-line system to the standby server, and be able to do this without bringing the system to it's knees. I recall that Sybase on Unix offered a replication server to do just what I am looking for. Unfortunately, the software developers didn't consider the repercussions of failures.
Can anyone offer me a solution?