I have a question about a SQL Server 2000 cluster. I created a two node SQL
cluster on Windows 2003, and the pattern is active/standby, single instance. When I ran a SQL
script on a remote client, during the processing, the active node crashed and failed over to the
second node successfully. Does that script continue to work after failover? If not, what will
happen?
Requires Free Membership to View
You have a single instance cluster. There is no such thing as active/passive in SQL Server 2000. That is old, inaccurate terminology that no longer applies. When a node fails in a cluster, the SQL Server shuts down. It is then restarted. Therefore, you get the same effect in a cluster as you get with a single machine when it fails, so no, the script will not continue to work. All open transactions will be rolled back upon the start up of the service, and you must restart the script.
For More Information
- Dozens more answers to tough SQL Server questions from Michael Hotek are available here.
- The Best Microsoft SQL Server Web Links: tips, tutorials, scripts, and more.
- Have a SQL Server tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical SQL Server questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, SQL Server, DB2, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
This was first published in March 2004
Join the conversationComment
Share
Comments
Results
Contribute to the conversation