Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlstrategist
Starting Member
3 Posts |
 Posted - 2012-11-13 : 15:36:50
|
| Hello All i hope this is a simple answer to what I am about to ask.Current Environment: SQL 2008 Cluster Type: Using failover cluster , which is only a hardware cluster for the SQL Databases. Active and Passive tied to netapp storage for the database. i know that i must install SQL 2012 on the passive node first.So my question is do I then failover the active node to passive server and then upgrade the active server? Next question would be then what about the database, it would not be upgraded. So would I need to do in this case? I hope it as simple as i think it is.Thanks,SQLStrategist |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-11-13 : 16:04:05
|
| http://msdn.microsoft.com/en-us/library/ms191295.aspx-Chad |
 |
|
|
sqlstrategist
Starting Member
3 Posts |
Posted - 2012-11-13 : 23:54:49
|
quote:
Originally posted by chadmat
http://msdn.microsoft.com/en-us/library/ms191295.aspx-Chad
Thanks Chad, this is the document that I have been going over. Unfortunately microsoft does not every give a direct answer to anything.It doesn't tell you if you need to failover the active node or not. I assume once the passive node is upgraded, run the upgrader on the active and let it failover on it on. |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-11-14 : 00:00:30
|
quote:
To upgrade a SQL Server failover cluster to SQL Server 2012, you must run setup with upgrade action on each failover cluster node, one at a time, starting with the passive nodes. As you upgrade each node, it is left out of the possible owners of the failover cluster. If there is an unexpected failover, the upgraded nodes do not participate in the failover until cluster resource group ownership is moved to an upgraded node by SQL Server Setup.By default, Setup automatically determines when to fail over to an upgraded node. This depends on the total number of nodes in the failover cluster instance and the number of nodes that have already been upgraded. When half of the nodes or more have already been upgraded, Setup causes a failover to an upgraded node when you perform upgrade on the next node. Upon failover to an upgraded node, the cluster group is moved to an upgraded node. All the upgraded nodes are put in the possible owners list and all the nodes that are not yet upgraded are removed from the possible owners list. As you upgrade each remaining node, it is added to the possible owners of the failover cluster.
Seems pretty clear to me.-Chad |
|
|
|
sqlstrategist
Starting Member
3 Posts |
Posted - 2012-11-14 : 10:48:47
|
| Ok. Thanks Chad. |
|
|
|
maryjohnson
Starting Member
3 Posts |
Posted - 2012-11-17 : 03:57:10
|
| Check out the server machines prices in pakistan and complete specification of them..http://www.computerprice.com.pk/desktops/servers.html |
|
|
|
|
|
|
|
|
Upgrading from SQL 2008 to SQL 2012 SP1