Hi I have 2 node Cluster sql 2005 on server 2003 and SAN and work very good for hardware failure.I wanna sometimes each service of sql goes down second node come active,I wan`t failover per service no hardware thank
Welcome to the forums. All the resources in cluster needs to be active when a failover happens. YOu need a better understanding of cluster and see what is referred in BOL: When working with SQL Server 2005 failover clustering, remember that the server cluster consists of a failover cluster instance that runs under Microsoft Cluster Services (MSCS). The SQL Server instance may be hosted by Microsoft MSCS-based nodes that provide the Microsoft Server Cluster. If problems exist on the nodes that host the server cluster, those problems may manifest themselves as issues with your failover cluster instance. To investigate and resolve these issues, troubleshoot a SQL Server failover cluster in the following order: Hardware: Review Microsoft Windows system event logs. Operating system: Review Windows system and application event logs. Network: Review Windows system and application event logs. Verify the current configuration against the Knowledge Base article, /ddue.schemas.microsoft.com/authoring/2003/5 NS = "http://ddue.schemas.microsoft.com/authoring/2003/5" />Recommend e d Private "Heartbeat" Configuration on a Cluster Server. Security: Review Windows application and security event logs. MSCS: Review Windows system, application event, and cluster logs. SQL Server: Troubleshoot as normal after the hardware, operating system, network, security, and MSCS foundations are verified to be problem-free.
