Solved

SQL2008R2 on Window2008R2Sp1 Active Active clustering

Posted on 2013-01-24
4
260 Views
Last Modified: 2013-01-28
Hi,

We already have Windows 2008R2Sp1 with SQL2008R2 on Active Passive cluster.

Any easy way to convert that to Active Active?  
Or should we install new Nodes and Setup new cluster then just move data over.

Anyone has any literature on SQL Active Active step by step instructions on blog or something would be great.    

Thanks
0
Comment
Question by:itmti
  • 2
4 Comments
 
LVL 23

Expert Comment

by:Ayman Bakr
ID: 38818324
Although this is related to 2003, I don't think there should be much difference:

http://www.sql-server-performance.com/forum/threads/active-passive-cluster-to-active-active-cluster.17534/
0
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 500 total points
ID: 38818949
there's some general confusion around what active/active means - it's not the same as load balancing, which I think is what you're asking about. Active/Active just indicates that you're running active resources on multiple cluster nodes, where active/passive means that all your active resources are running on a single cluster node.

A single-instance cluster is active/passive by nature, since you only have one resource to run, so it can only run on a single node at any given time. If you add a second clustered sql server instance, you can run it on the other node (active/active) or the same node as the first instance (active/passive). This isn't a setting you change somewhere to set it - it just indicates where you're running your resources, and can change at any time when you move a resource.

I wrote an EE article about cluster terminology that attempts to clear up the active/active vs. active/passive confusion, but it's still in editor approval - in the meantime, I have a blog post that covers much of the same material and might be worth taking a look:

http://trycatchfinally.net/2012/09/clearing-up-windows-cluster-terminology/
0
 

Author Closing Comment

by:itmti
ID: 38819025
Thank for explanation.
0
 
LVL 28

Expert Comment

by:Ryan McCauley
ID: 38828063
Not sure if there's still anything to clear up, but my EE article about clustering was published, if you're interested:

http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/A_11134-Shedding-some-light-on-Windows-clustering-terminology.html
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now