Hi there,
I have been experimenting with sql server 2000 clustering on windows 2003 server (Enterprise Edition) - using majority node set server cluster.
We have two servers setup:
1. SQL1
2. SQL2
If SQL2 dies, the db remains open and the virtual server is still contactable. However if SQL1 dies the virtual server goes down.
Does anyone have a link to documentation on how to setup this kind of clustering or any other idea's that I may try?
I have been experimenting with sql server 2000 clustering on windows 2003 server (Enterprise Edition) - using majority node set server cluster.
We have two servers setup:
1. SQL1
2. SQL2
If SQL2 dies, the db remains open and the virtual server is still contactable. However if SQL1 dies the virtual server goes down.
Does anyone have a link to documentation on how to setup this kind of clustering or any other idea's that I may try?