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.

 All Forums
 SQL Server 2012 Forums
 Other SQL Server 2012 Topics
 Upgrading from SQL 2008 to SQL 2012 SP1

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
Go to Top of Page

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.
Go to Top of Page

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
Go to Top of Page

sqlstrategist
Starting Member

3 Posts

Posted - 2012-11-14 : 10:48:47
Ok. Thanks Chad.
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -