[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

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

Posted on 2009-04-09
2
Medium Priority
?
680 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

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

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…
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 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 configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

649 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