I am using Veritas Replication exec to replicate my SQL files from one server to the other. I replicate all of the databases, including master and model. In the event of a primary SQL failure, all I have to do is bind the IP address from the primary box to the secondary box and start the SQL service. I do not have any scripts to do this automatically, but I can live with a 10 min downtime. For us the most important feature is little or no data loss. Keith Keith Sirmons Microcomputer/LAN Administrator College of Veterinary Medicine >>> emann@xxxxxxxxxxxxxxxxxxxxx 8/16/2005 1:20:39 PM >>> If one of your failover situations requires restoring from backup, then that's not a very high level of redundancy. I wouldn't consider it to be high availability, and only "half" of failover. Drives are going to be the most common thing to fail in a heavy use server. The processor, power supplies, and mainboard doesn't get the type of mechanical abuse HDD's do. From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of Bray, Donovan (ESC) Sent: Tuesday, August 16, 2005 2:18 PM To: thin@xxxxxxxxxxxxx Subject: [THIN] Re: Slightly OT: SQL Redundancy Put "EMC/Legato's FullTime AutoStart/SE (formerly Co-StandbyServer AAdvanced)" on your list to check out. I have it on the way to replace our MSCS Exchange Cluster. The advantage of Autostart is that we can use block level mirroring between nodes and eleminate the single point of failure of the shared scsi resource. We opted not to use clustering for our SQL boxes due to the steep processor licensing as you have to graduate to Enterprise processor licenses. What we opted to do is buy two hardware boxes that are totally identical, Each loaded with 2gb RAM (Max for Standard), we licensed the ACTIVE box for its Dual Processors. We use the spare box just as a test/development box. Both boxes are configured with two 146gb ultra3 hot-swap scsi drives in a hardware mirror. 24gb system partition, the rest is for SQL on a secondary partition. If there is a failure on the primary server, I have dedicated hardware already in the rack, powered on, ready to recieve the drives from the failed box. If the failed box's drives are whats suspect, then I have to restore from backup. Your business realities may be different and not allow you to have this kind of manual failover. But the alternative in our case was just too expensive to justify. From: Joe Shonk [mailto:joe.shonk@xxxxxxxxx] Sent: Tuesday, August 16, 2005 8:55 AM To: thin@xxxxxxxxxxxxx Subject: [THIN] Slightly OT: SQL Redundancy Hello, What a success (or failure) has the group encountered in making SQL servers Highly Available? Either through clustering (Microsoft or third-party) or replicated partners. We are looking to move the Citrix DataStore and a few application databases to a HA solution, while minimizing the impact to farm in event an HA partner goes down. Joe