I am quite confused between the service cluster and the load balancing. Is there any pro of Cluster over the load balancing since as I know actually load balancing can do cluster also? E.g I have 3 machines with load balancing A, B, C. If B machine is down, the clients still switch to A or C which is the cluster purpose and provide high availability. I don't understand why need service cluster since it is active-passive only. I think it is just used in several different resources sharing in different machines environment. or application does not support load balancing.
Is there any called load-balanced cluster? Does it combine service cluster and load balancing or it is a type of load-balancing only? But really don't understand the pro of combining 2 services
Another question is MS SQL 2008 supports load balancing? If so, SQL 2008 has specify setting to set the load balancing or just replication? No need to set the NLB in 2008?