Solved

SQL 2008 R2 to 2012 Failover Cluster in-place upgrade

Posted on 2013-06-21
3
2,679 Views
Last Modified: 2013-06-24
Hi!

I'm planning to do an in-place upgrade of our SQL 2008 R2 Failover Cluster to 2012. If any of you have done this already, would you care to share?

Steps I've in mind:
1. Pause or evict (?) the passive node from the cluster
2. Upgrade Windows 2008 R2 to Windows 2012 - reboot the server?
3. Upgrade SQL 2008 R2 to SQL server 2012
4. Restart the node
5. Make sure Failover Cluster settings are intact.
6. Failover cluster to this passive node (passive will then become active node)
7. Repeat #1 - 5 until the other node is upgraded
8. Test failover and failbacks few times.
9. Check database connectivity
10. Finish!

There may be some steps in between the above steps to carry out that I have no knowledge about. Please let me know what they are!

Thanks, Sharad
0
Comment
Question by:sharad_rai
  • 2
3 Comments
 
LVL 8

Assisted Solution

by:didnthaveaname
didnthaveaname earned 350 total points
Comment Utility
I would take a look at this article first and foremost: http://technet.microsoft.com/en-us/library/ms191295.aspx - looks like you can do rolling upgrades relatively painlessly.
0
 

Author Comment

by:sharad_rai
Comment Utility
Thanks, the link is pretty useful.
What is the suggested method of backing up the nodes before going into the upgrade cycle?

- Sharad
0
 
LVL 8

Accepted Solution

by:
didnthaveaname earned 350 total points
Comment Utility
I would imagine you just back up all of the databases on the passive nodes before you upgrade them (since the upgrade will upgrade the databases).  Technically speaking, you'll never be upgrading an active node, since you'll failover to an upgraded node before you upgrade the active node.

Where the link I posted gets me to thinking is where it mentions that upgraded nodes don't participate in the cluster until the cluster resource group ownership is moved to an upgraded  node, which, by default, automatically occurs during the upgrade of the next node after half of the nodes have been upgraded.  If this is a 2-node cluster, I would imagine there is going to be some manual intervention required.  I am, unfortunately, not going to be of a whole lot of use on the specifics as I avoid clusters like the plague (definitely intrigued by the 2012 availability groups, however).
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

OfficeMate Freezes on login or does not load after login credentials are input.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

763 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now