question

kaveri avatar image
kaveri asked

Active/Active sqlserver 2008 on node1 and sqlserver2008 R2 on node2 cluster configuration

Hi All , My requirement is to Active/active cluster configuration , for sqlserver 2008 on node1 and sqlserver 2008 R2 on node2 , please help me how to setup this cluster and send me some links for reference if any one have will be appreciate.
sql-server-2008sql-server-2008-r2clustering
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WilliamD avatar image
WilliamD answered
MSDN is your best bet - there are a wide range of whitepapers and tutorials out there that can go into way more depth than is practical to provide as an answer here. Let me help you get started though: [How to install a SQL Server Cluster reference materials][1] I can't imagine a mixed version Active Active cluster really being such a good idea though. I would stick to either all 2008 or all 2008R2 [1]: http://lmgtfy.com/?q=sql+server+2008+cluster+installation
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image
Kev Riley answered
You can have a cluster running different versions, but not each node if you wanted the cluster to act as a failover cluster. Just as a single machine can run a 2000, a 2005, a 2008 and a 2008R2 instance, a single cluster can do the same, but if the 2008R2 node failed, and the other node only had 2008, then it wouldn't be a failover cluster. Why do you want to have different versions on each node?
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

yeek avatar image
yeek answered
You should be even mix SQL Server 2005 with SQL 2008, I don't see any problem this will not work. As for Kevin Riley's question "Why do you want to have different versions on each node?", the reason is that not all vendor applications will be compatible to same version of SQL Server. Sometimes, you do have to mix versions on same cluster.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.