?
Solved

How do I setup a Active Active SQL Cluster in Windows 2008 server

Posted on 2009-04-09
2
Medium Priority
?
679 Views
Last Modified: 2012-05-06
Hi ,
I have set up three virtual servers(Windows 2008 enterprise Edition) with fail over clustering feature installed and the cluster is also created by adding the three servers as three nodes..Now I would like to know the steps to create ACTIVE/ACTIVE SQL cluster ..(I have already implemented the Active /Passive set up for sql and is working fine)....

Please help
Thanks
PK

0
Comment
Question by:pappan73
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 10

Accepted Solution

by:
ashwin_kumar525 earned 500 total points
ID: 24114815
Active/Active means nothing but installing another instance of SQL on to the same nodes, 1 node will be active for instance1 and another node will be active for instance 2. Follow the same procedure as if yo were installing it again and this time install SQL with a named instance.

May be in your case, you need to setup three instances of SQL so that each node can be active for each instance.

any further questions?
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Suggested Courses

777 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