jitendra.padhiyar (1/4/2013)
Hello Masters,I have clusters on sql server 2008R2, I am learner for clustering on sql. So can you pls guide me regarding cluster on sql server 2008? I can see on one node sql services are up and running and on another server is stopped ? Why so?
For each clustered instance installed that is correct. The active node will have the services started. Since the partner nodes will not be holding any resources the services cannot be started.
jitendra.padhiyar (1/4/2013)
I heard its active-active clustering, If its active active than sql services should be up on both the servers correct?
So you have more than 1 instance installed and running on multiple nodes?
Don't get confused with Oracle RAC that is not what failover clusters provide
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉