We help IT Professionals succeed at work.
Get Started

SQL Cluster 2nd Instance Installation

702 Views
Last Modified: 2012-05-10
At a high level what are the steps to install a 2nd instance of SQL 2k8 in a two node active/passive windows 2008 R2 Cluster?

Please verify they are:

1)  Setup a new disk that will be shared between the two nodes

2)  Under storage add the new disk into the cluster on node 1

3)  Run SQL 2k8 setup and install on the first node, the instance root directory will be C: (different dir from the 1st instance) but the data directory will be installed on the new disk I added to the cluster

4)  Than run setup on the 2nd node but choose "add node to sql server failover cluster" at the beginning of setup, than go through and do the same, select drive C: for the root directory and the new disk for the data directory.

The part I'm unsure about is #4 - because this is a 2nd instance I'm not sure if I choose add node.  Also would I fail over the 1st sql instance to the 2nd node before installing sql again?  

If you could clarify the install procedure on the 2nd (passive) node that would be great.

Thanks,
Comment
Watch Question
Senior Data Architect
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE