Solved

How To Add an additional SQL Cluster Group on an existing SQL 2008 R2 Cluster in Windows 2008 Server

Posted on 2010-11-24
2
501 Views
Last Modified: 2012-08-14
I have a SQL 2008 R2 Cluster Failover setup for 2 physical nodes running windows 2008 Server.  I have sucessfully setup the MSDTC and SQL Resources (Analysis services, SQL Server, SQL Server Agent and Full Text resources on it with 3 physical drives.  All of this setup in a Virtual environment using Hyper-V using a simulated image iScsi Drives from Starwind software.  I like to add another cluster group to this cluster with the following:
SQL Network Name, IP, 3 more Drives and the same SQL Resources above.  Can I Add these resources in the cluster manager?
0
Comment
Question by:HaldunIT
[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 4

Accepted Solution

by:
rlog earned 500 total points
ID: 34215705
Yes you add this in cluster manager. Configure a service or Application. You don't have to configure the DTC again just install the new cluster instance.
0
 
LVL 19

Expert Comment

by:Bhavesh Shah
ID: 34221033
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

726 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