Jim Felton <> wrote: > Dawn, we are looking at SQL 2000 replication right now. Can it be > setup to do an automatic roll over to the backup server if the main > server fails? > > TIA, > Jim > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf > Of Dawn Tierno-Culda > Sent: Monday, October 09, 2006 12:33 PM > To: [email protected] > Subject: RE: [NF] - SQL- Database Replication > > 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
No. You have to buy into a third party to accomplish that. You will find it is NOT CHEAP, buy any CYA that works is going to be expensive. For a pair of servers figure 10,000 + USD. That is for the full blown switch over with no loss of data and not human interaction with your network so your code asking for data still works. Stephen Russell DBA / .Net Developer Memphis TN 38115 901.246-0159 "Our scientific power has outrun our spiritual power. We have guided missiles and misguided men." Dr. Martin Luther King Jr. http://spaces.msn.com/members/srussell/ -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.407 / Virus Database: 268.13.1/466 - Release Date: 10/7/2006 _______________________________________________ Post Messages to: [email protected] 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.
