Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Please Please help me- upgrading to sql 2008 R2 enterprise edition from sql standard edition on SQL Failover Cluster Expand / Collapse
Posted Friday, June 7, 2013 7:54 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 8:31 AM
Points: 236, Visits: 934
I'm currently looking into the possibility of configuring a 2008 R2 failover cluster for my organisation. I'm curious as to what I will need to do. Is there some best practices guides or reference material that is a good place to learn about this?

Here is the current setup which is done by other dba;

single node with SQL 2008 R2 Standard RTM version (no service pack installed) DBA removed the other node

Here is what I have to do;

Upgrade both the nodes to SQL 2008R2 enterprise with SP2 and add the second node for failover cluster.

What will be the steps I have to take? Does it matter which node needs to be upgraded first at this point? What will be the process to have active / active node? Can some one please send me step by step guide or any site that I can get the idea how to set up the active/active or active / passive cluster. God Bless!

Thanks for your help.
Post #1461091
Posted Monday, June 10, 2013 6:29 AM



Group: General Forum Members
Last Login: Yesterday @ 4:10 PM
Points: 7,985, Visits: 16,022
My 3 part guide is a good source, they're linked below

Part 1

Part 2

Part 3


"Ya can't make an omelette without breaking just a few eggs"
Post #1461512
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse