SQL Server Performance Forum – Threads Archive

SQL Server 2000 Cluster Fail-over questions

I am new to SQL Server Clustering and just worked with a partner on configuring a two node cluster on a Windows 2003 server and SQL Server 2000 in an Active/Passive design with one instance. While performing the fail-over tests to check that the cluster is working properly we began to fail over the individual groups. It just so happened that the customer was near by to observe our fail-over test and raised the following concerns. During the Failing over of the separate groups, the system is in an Active/Active state for the moment because the groups are split between the nodes. Theoretically, I think the customer is correct but it shouldn#%92t be a concern because fail-over is not considered complete until all groups have failed over. I think the question is not relevant. Please provide feedback on this. Is there a way to create dependencies on the groups that when one fails over all groups will automatically follow? Although I think the customer is a bit paranoid, this sounds like a valid question. On the other hand, I think when you need to perform maintenance on one node, just fail-over the entire node. What do you think? Note:
These question are based on the manual fail-over test during the configuration of the windows and sql server cluster. Hope this helps a bit.

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part4/c1261.mspx
http://www.sql-server-performance.com/real_life_dba_cluster_failover.asp
…links to get more information on the questions. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided Ã¯Â¿Â½AS ISÃ¯Â¿Â½ with no rights for the sake of knowledge sharing.

]]>