SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 Other SQL Server 2012 Topics
 Upgrading from SQL 2008 to SQL 2012 SP1
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sqlstrategist
Starting Member

3 Posts

Posted - 11/13/2012 :  15:36:50  Show Profile  Reply with Quote
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

USA
1974 Posts

Posted - 11/13/2012 :  16:04:05  Show Profile  Visit chadmat's Homepage  Reply with Quote
http://msdn.microsoft.com/en-us/library/ms191295.aspx

-Chad
Go to Top of Page

sqlstrategist
Starting Member

3 Posts

Posted - 11/13/2012 :  23:54:49  Show Profile  Reply with Quote
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

USA
1974 Posts

Posted - 11/14/2012 :  00:00:30  Show Profile  Visit chadmat's Homepage  Reply with Quote
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 - 11/14/2012 :  10:48:47  Show Profile  Reply with Quote
Ok. Thanks Chad.
Go to Top of Page

maryjohnson
Starting Member

USA
3 Posts

Posted - 11/17/2012 :  03:57:10  Show Profile  Reply with Quote
Check out the server machines prices in pakistan and complete specification of them..
http://www.computerprice.com.pk/desktops/servers.html

Edited by - maryjohnson on 11/17/2012 03:58:03
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.07 seconds. Powered By: Snitz Forums 2000