Why not use SQL 2000's replication feature. -----Original Message----- From: Jim Felton [mailto:[EMAIL PROTECTED] Sent: Monday, October 09, 2006 12:12 PM To: [EMAIL PROTECTED] Subject: RE: [NF] - SQL- Database Replication
The two servers are on different power and UPS sources and have RS-422 interconnects to the Dual device servers that are very tightly tied together. While splitting the two systems into separate racks/rooms is possible, it's not practical. Thanks, Jim -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hal Kaplan Sent: Monday, October 09, 2006 9:38 AM To: ProFox Email List Subject: RE: [NF] - SQL- Database Replication => -----Original Message----- => From: [EMAIL PROTECTED] => [mailto:[EMAIL PROTECTED] On Behalf Of Jim Felton => Sent: Sunday, October 08, 2006 08:54 => To: ProFox Email List => Subject: RE: [NF] - SQL- Database Replication => => Stephen, The two server are mounted in the same rack. They => are used for a broadcast TV automation system. The SQL => servers hold the Metadata for video recording and playback. => The Metadata comes from user input, IP based Internet and => satellites feeds, Baseband recordings from tape or live => broadcasts, automated video ingestion and automation => control. We aren't looked for two systems updating one => database at the same time; we are looking for real time => redundancy to protect use from hardware failure. We are => trying to eliminate a singe point of failure and these => servers are the last piece to the puzzle. => All right, what am I missing here. IMHO, for such a critical system mounting both in the same rack is one of the dumbest things you can do. Am I wrong? Please explain. TIA HALinNY [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.