Cluster failover on SQL server
Posted on 2011-05-12
I have SQL 2005 (Bussness intelligence) and SQL 2008(biztalk) installed on the same server in cluster,
Cluster has 5 resource groups looks like this
Cluster Group (Cluster name ,Quorum and Quorum IP)
MSDTC(MSDTC IP, MSDTC Network Name....)
Group BI(SQL server 2005, SQL Agent....)
Group BT(SQL 2008, SQL agent...)
here is question
when Cluster Group BI fails, Group BT SQL server and agent terminates (viceversa) and i had to failover the BT to start the SQL server and agent.
Is there a possibility where if one services fail on Either on Group BI or BT, i need the other resources(all the remaining resources) to be failedover.