Solved

Adding instance to sql cluster

Posted on 2011-02-14
7
558 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
7 Comments
 
LVL 39

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 39

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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 39

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 42

Assisted Solution

by:EugeneZ
EugeneZ 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

773 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