Jim, We have exactly the same system at work and we looked around for 18 months trying ALL the possibilities and the one which came out top and we installed was Doubletake. I looked at about 10 products for evaluation and none of them even came close.
Our requirement was to be able to literally pull the plug on the main server and have the backup server take over control within 5 seconds. As a matter of course we do this every month to make sure the system performs OK. The secondary backup server immediately assumes an additional IP address which was held by the Primary (now dead) server and continues the live system. There is inbuilt additional support for SQL server which we also use. Most of the systems out there will cater for SQL server but only in as much as providing basic replication which is available as standard in SQL as it is. We run lots of VFP DBC/DBF files and none of the other systems could cater for the system dying whilst DBF's were open. The worse case scenario we have had was to have to do a reindex which we do as a matter of course once a month anyway. In addition Doubletake can do times snapshots to disk/tape and we have a tertiary server doing this from the secondary server every 30 minutes. Don't just take what manufacturers say for granted. Ask to see a LIVE demonstration with your files. That usually sorts out the men from the boys! Doubletake isn't exactly cheap but for a 24/7 system its unbeatable in my experience. Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jim Felton Sent: 07 October 2006 21:47 To: [EMAIL PROTECTED] Com Subject: FW: [NF] - SQL- Database Replication -----Original Message----- From: Jim Felton [mailto:[EMAIL PROTECTED] <mailto:[mailto:[EMAIL PROTECTED]> Sent: Saturday, October 07, 2006 9:31 AM To: ProFox Email List Subject: [NF] - SQL- Database Replication I'm hoping one of you SQL gurus can help me out. I have two MS SQL 2000 Servers which are used as a Main and Backup server. The Main is online 24X7. What I need to do is keep the Backup server up to date in a real time. So if I have a Main server failure I can fall back to Backup server with all the current information in the database. Does anyone have a similar environment and how did you solve the problem? TIA Jim --- StripMime Report -- processed MIME parts --- multipart/mixed text/plain (text body -- kept) application/ms-tnef --- [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.