x

Add new instance to an existing SQL Cluster

Dear Experts,

We have a requirement to create a new instance on a existing SQL Server 2008 (Windows 2008) cluster. We have already one instance running on the cluster and we have to create a second clustered instance.

So far, I have colected the following:

  1. One non pinging IP address from the same subnet where the server lies.

  2. One domain service account.

  3. Selected a insance name for the new instance.

  4. A 50 GB new disk is already added to the Windows cluster. It has not been added to the existing SQL Resources Group. Its just online now.

I have been reading different blogs but unable to get a clear step by step documentation for doing this. I have not installed SQL cluster before and this requirement is little tricky above that.

I will request your help for the following:

a. what are all the prerequisite resources needed befor starting the installation.

b. Step by step installation procedure.

c. Any special considerations that has to taken care (pre and post installation).

The existing cluster has already a Quorum and MSDTC. So I can use them for the second instance I believe.

Please need guidance on this.

Regards,

more ▼

asked Jun 19, 2012 at 07:27 PM in Default

uttamsahoo gravatar image

uttamsahoo
1 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Before you start you'll also need a new network name (I would recommend creating the computer object in advance in AD, disabling it and granting full permissions on that to the cluster computer account).

Step-by-step install is a little too much to go into on a forum, I would recommend picking up Allan Hirt's book [Pro SQL Server 2008 Failover Clustering][1] which covers everything that you need to know (including a step-by-step walkthrough for installs).

Post install you will need to ensure that you have your memory settings configured correctly perform failover testing for both instances.

[1]: http://www.amazon.com/Server-Failover-Clustering-Experts-Voice/dp/1430219661/ref=sr_1_1?ie=UTF8&qid=1340204910&sr=8-1&keywords=allan+hirt
more ▼

answered Jun 20, 2012 at 03:10 PM

SirSQL gravatar image

SirSQL
4.8k 1 3

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1850
x93

asked: Jun 19, 2012 at 07:27 PM

Seen: 1198 times

Last Updated: Jun 20, 2012 at 03:10 PM