HI
I have two Dell Servers(For high avaiablity each machines have three intel gigabit Networkcards,one for heatbeat,two for clients link) with a disk array.I have installed Windows2003 and setup the Cluster,it's worked well,then i installed sql server 2000 EE on them through many articles(I created tow sql ip address because i have two nics on each servers).When one node fail,the resource can shift to another node,the sql service is still available.Ok,but when one switch of the two seperate network is down,the sql service is nolonger avaliable,there is no use for another network cards on each node? Is there any articles for sql server's installation for nodes with three nics
Another problem is that it take about 3 min for sql resource such as sql ip address,sql network name,sql server etc to transmit from one node to another,obviously it's too long,but i can't solve it