Server - HP-UX (HP-UX xxxxxx B.11.11 U 9000/800)
ERP - Pronto ERP (www.pronto.com.au
Database - C-Isam with SQL reporting
We are about to move to a new data warehouse (blade servers) and also have a new DR server at a seperate site approx 16k away. We have created an extra 150+ programs (+ their own DB tables) that tie-in to Pronto and due to their complexity it would be impossible to log all transactions and subsequent entries to every table and therefore restoring trans from log files is not an option. There is approximately 17gb of live critical data. Some tables/files are over 2gb each.
Our requirement is to have the DR as up to date as possible in the event of a disaster. Restoration from overnight back-ups is not an option as it would take too long to input the trans since last backup.
Is there an efficient solution to replicate (new) data/trans to the off-site DR without chewing up a lot of costly bandwidth traffic ??
Thanks in advance