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:
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.
asked Jun 19 '12 at 07:27 PM in Default
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] 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.: 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
answered Jun 20 '12 at 03:10 PM