Solved

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

Posted on 2009-04-09
2
674 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
windows 10 versions 3 33
SQL Help 27 40
Whitelisting applications 2 20
why sql server only update some statistics in the database ? 3 18
In this article I will describe the Backup & Restore 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.
Why should I virtualize?  It’s a question that’s asked often enough.  My response is usually “Why SHOULDN’T you virtualize?”
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
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…

816 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

11 Experts available now in Live!

Get 1:1 Help Now