asked on

MS SQL Server 2008 R2 Multi Instance Cluster

Experts,

I'm planning to setup Multi-instance (Active/Active) Cluster using MS SQL Server 2008 R2 on Windows 2008 R2. The reason for this setup is to achieve better utilization of the hardware (since both the servers will be used to support database transactions).

My intention is two have two instances in the cluster with one running on node 1 and other running on node 2 and they will failover to the other nodes in case of any issues. I'm trying to get some direction to achieve this, and I'd appreciate if somebody can point me to the right direction and hopefully provide some link if they've implemented the same setup.

Thanks

SOLUTION

arnold

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Ryan McCauley

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

sqlserverdba

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

arnold

You can install on the same node and shift them as you see fit. Designating which node will have which instance active is part of the configuration and does not require the installation to occur on that node.

SOLUTION

St3veMax

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Ryan McCauley

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial