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.