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.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stephen the Cook Sent: Saturday, October 07, 2006 6:46 PM To: 'ProFox Email List' Subject: RE: [NF] - SQL- Database Replication Jim Felton <> wrote: > 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? How far apart are the servers? How is the data stored on the primary server? I have done a Cluster, where 2 servers will do the work of one. One is your primary and the second is a backup. Data must be on a SHARED drive (SAN, or similar type of data storage device). You will have to make a named instance of SQL instead of just the SeverName. Say that your server is thrashing in a blown away query. You can down that server and the other will pop up to handle all requests. When you bring it back up it's running at full bore. It's an every 90 days issue I have found. Stephen Russell DBA / .Net Developer Memphis TN 38115 901.246-0159 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.0/465 - Release Date: 10/6/2006 [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.