SQL Server Performance Forum – Threads Archive

Question about failover

Hey forum, I have a question. I am in the midst of getting a two node cluster into production. Its an active/passive configuration, running Windows2k Adv & MS SQL 2000. Both nodes are sharing a Dell storage system via SCSI bus. The shared storage is raid 10. Not sure if more information will be needed but my question is pretty basic. If I am in the middle of a sql query and the primary node fails, the secondary node picks up in about 6 seconds, but the query breaks as soon as failover begins, is this customary? Or do I have a mis-configuration problem. TIA,
Joe

---

The query will break and it is expected behaviour. Doing a failover is the same thing as stopping and starting the SQL service on a stand alone server. /Argyle

---

Hey Argyle your the man. Thanks for the quick response! I really appreciate it. Wish I could get quick answers like that to all my little troubles in life <img src=’/community/emoticons/emotion-1.gif’ alt=’‘ /><br /><br /><br />Joe

---

I might also add that it is important for applications to be cluster-aware, so that they can recover after a failover. As a bad example of how to write software, we run an ERP product that is so stupid that after a failover, the app is not able to reconnect to the database, and has to be restarted. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com

---

]]>