x

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.
more ▼

asked Apr 27, 2011 at 12:47 AM in Default

kaveri gravatar image

kaveri
11 1 1 1

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

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
more ▼

answered Apr 27, 2011 at 03:19 AM

WilliamD gravatar image

WilliamD
25.9k 17 19 41

(comments are locked)
10|1200 characters needed characters left

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?
more ▼

answered Apr 27, 2011 at 07:49 AM

Kev Riley gravatar image

Kev Riley ♦♦
52.8k 47 49 76

(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Aug 04, 2011 at 06:45 AM

yeek gravatar image

yeek
1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1834
x582
x46

asked: Apr 27, 2011 at 12:47 AM

Seen: 2428 times

Last Updated: May 17, 2013 at 02:35 AM