Interesting that you should write this. My brother in law is also an SQL "guru," and tells me he can set up the sql server to save the AC data in two different servers simultaneously, but he would need to install the full sql server, whatever that means. I, of course, have no idea what it would entail but I would love to have that degree of redundancy in my office. I already had 1 episode where the power supply for my main server died and I spent 2 days getting a new one. Needless to say, having another backup server with no down time would be extremely valuable.

In the meantime I am buying a second server with redundant power supply and hot swappable hard drives in raid configuration to hopefully prevent this from happening again.

Last edited by gcarcamo; 06/27/2009 10:43 AM.

Gerardo Carcamo
Surgeon
San Antonio, TX