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
Solved

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

Posted on 2009-04-09
2
675 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
2 Comments
 
LVL 10

Accepted Solution

by:
ashwin_kumar525 earned 125 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Why I am having this error in my query? 2 25
TSQL recursive CTE challenge... 8 29
NTP problem 24 41
SQL Server 2008 R2, need a pivot/cross tab query... 4 27
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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.
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
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…

808 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