Solved

Adding instance to sql cluster

Posted on 2011-02-14
7
561 Views
Last Modified: 2012-05-11
We have a 2 node sql cluster and need to install another instance.  This instance will be installed on Node1 (both  nodes are 'active').  I have never done this before and was hoping someone could provide explicit instructions on how to install a new instance (named of course) and also how to go about applying the patch.
0
Comment
Question by:sqlnewbie08
[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
7 Comments
 
LVL 40

Accepted Solution

by:
lcohan earned 300 total points
ID: 34891811
0
 

Author Comment

by:sqlnewbie08
ID: 34891873
Yes... I am aware of this.  We are having all the necessary infrastructure in place before the install begins (separate virtual server, ip address, luns ...).  What i've never done is install a new instance on an exisiting clustered environment and then patch the new instance.  That is what I  need to know how to do.
0
 
LVL 40

Assisted Solution

by:lcohan
lcohan earned 300 total points
ID: 34892094
Ok, so if you have dedicated disks, IP, etc. please see articles below and do all these in a TEST environment first not directly to PRODUCTION environment. Also no matter what you do, because SQL is clueter aware and you have already a cluster built and running, perform ALL actions on ACTIVE node during downtime and from Cluster Manager exclusively including service packs/patches.

We did similar thing in dev/testing and did not worked verry well so we will be building brand new environment for SQL 2008 soon then migrate our prod DB's db's to that environment.

SQL Server 2005 Failover Clustering White Paper
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en


You cannot find SQL Server cluster resources in Failover Cluster Manager after you install a SQL Server 2005 failover cluster on a computer that is running Windows Server 2008
http://support.microsoft.com/kb/932897

Lessons Learned
http://technet.microsoft.com/en-ca/library/cc917532.aspx
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 40

Assisted Solution

by:lcohan
lcohan earned 300 total points
ID: 34892107
Oh yeah...I remember we had quite some fun with admin domain accounts running the patches that were "named" differently on active directory vs no active directory domain.
0
 
LVL 43

Assisted Solution

by:Eugene Z
Eugene Z earned 100 total points
ID: 34892982
if you have set 1st node and have set shared drives and got ip for new sql server:
check:

How to: Add or Remove Nodes in a SQL Server 2005 Failover Cluster (Setup)
http://msdn.microsoft.com/en-us/library/ms191545%28v=SQL.90%29.aspx


How to Cluster SQL Server 2005
http://www.sql-server-performance.com/articles/clustering/cluster_sql_server_2005_p1.aspx

0
 

Author Comment

by:sqlnewbie08
ID: 34897114
I've reviewed all these docs ...  none of the specifically let you know how to add an instance to an existing cluster.  
0
 

Assisted Solution

by:publicvoid
publicvoid earned 100 total points
ID: 34899285
Make sure your new disk group is on Node1 and run the SQL installer from there (you will need to choose the appropriate path for your data files during the installation).

Here is a good article, complete with screen shots:

http://www.sql-server-performance.com/articles/clustering/cluster_sql_server_2005_p1.aspx

Note that for SQL Server 2005, the installer will install the binaries on all of the nodes in the cluster (unless you explicitly remove them, not recommended). Also be aware that even though you are installing a NEW SQL instance, your existing instances MAY be restarted during the installation. If you are running this on a production cluster, you may want to perform the installation when this is acceptable.

As for patching your clustered SQL instances, simply run the appropriate EXE on a cluster node (make sure you have the correct CPU architecture...x86 or x64). The installer will find all of your SQL instances and let you patch them all together (and will patch all of the nodes in the cluster). Of course, expect SQL service restarts while the patch is running and possible server reboots once patching is complete.
0

Featured Post

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

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

Suggested Solutions

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
I have a large data set and a SSIS package. How can I load this file in multi threading?
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.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

751 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