April 28, 2010 at 6:02 pm
From the SQLServer2008FailoverCluster document:
Unlike earlier versions, when you install or upgrade a SQL Server 2008 failover cluster, you must run the setup process for SQL Server individually on each node of the failover cluster
We have 3 node active/active/passive cluster setup for SQL Server 2005 and want to upgrade to SQL Server 2008 using in-place upgrade method. On node1, we have one instance and on node2, we 4 instances and node3 is passive. So according to the above statement, do we need to run the SQL Sevrer 2008 setup on node1 once and on node3, 4 times and node3, once?
And what is the order to follow to run the SQL Server 2008 setup? i.e 1st, once on passive node3, then once on active node1 & 4 times on active node2?
Please correct me if I understand wrong
Thanks
April 28, 2010 at 11:33 pm
It sounds that you have only one instance of SQL Server running on these 4 node cluster. If that is the case then you need to run your installation first on active node and once active node installation is complete then need to run on every node. During installation, it will prompt you to select SQL Server Instance name and upon selection on instance it will show you all nodes (preferred/dependencies) related with that instance.
[font="Verdana"]--www.sqlvillage.com[/size][/font]
April 29, 2010 at 9:37 am
It sounds that you have only one instance of SQL Server running on these 4 node cluster
NO, On node1, we have one instance and on node2, we 4 instances and node3 is passive
April 29, 2010 at 10:30 am
In that case,
1. Install sql server on node1 for instance running on node 1
2. Install sql server on node 2 for instances running on node 2
3. Install sql server on node 2 to add instance running on node 1
4. install sql server on node 1 to add all instances running on node 2
5. install sql server on node 3 to add all instances running on node 1 and node 2
** you can start 1 and 2 in parallel
[font="Verdana"]--www.sqlvillage.com[/size][/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply