Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2008 failover 2 node (A/P) license upgrade from STD to ENT Expand / Collapse
Author
Message
Posted Friday, January 17, 2014 8:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 28, 2014 2:12 AM
Points: 6, Visits: 15
We have a 2 node STD sql 2008 sql failover cluster running A/P mode

We want to upgrade the sql lic from STD to ENT but do not want any downtime.
Ie. Rolling Upgrade..

Is this straight froward of upgrading the passive node, testing access to dbases (incl system dbases) via passive, then failover active to passive, and upgrade the new passive..

What about rollback.. if the first stage upgrade of the passive works, but we get dbase errors. can we rollback the upgrade on the passive, does it cause any issues with the master dbase etc..

cheers
Post #1532089
Posted Friday, January 17, 2014 9:26 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:34 AM
Points: 6,269, Visits: 13,505
Spud312R (1/17/2014)
We have a 2 node STD sql 2008 sql failover cluster running A/P mode

We want to upgrade the sql lic from STD to ENT but do not want any downtime.
Ie. Rolling Upgrade..

Is this straight froward of upgrading the passive node, testing access to dbases (incl system dbases) via passive, then failover active to passive, and upgrade the new passive..

What about rollback.. if the first stage upgrade of the passive works, but we get dbase errors. can we rollback the upgrade on the passive, does it cause any issues with the master dbase etc..

cheers

The following Microsoft article How to: Upgrade to a Different Edition of SQL Server 2008 R2 (Setup)
details this

Microsoft Developer Network
Note
SQL Server in a clustered environment: Running edition upgrade on one of the nodes of SQL Server cluster is sufficient. This node can be either active or passive, and the engine does not bring the resources offline during the Edition Upgrade. After the edition upgrade it is required to either restart the SQL Server instance or failover to a different node.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1532131
Posted Monday, January 20, 2014 7:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 28, 2014 2:12 AM
Points: 6, Visits: 15
Many thanks for this, is there a procedure if i need to rollback to std from ent editions?
I assume the lic upgrade modifies some of the system dbases ??

This is handy to know
"SQL Server in a clustered environment: Running edition upgrade on one of the nodes of SQL Server cluster is sufficient"


Perry Whittle (1/17/2014)
Spud312R (1/17/2014)
We have a 2 node STD sql 2008 sql failover cluster running A/P mode

We want to upgrade the sql lic from STD to ENT but do not want any downtime.
Ie. Rolling Upgrade..

Is this straight froward of upgrading the passive node, testing access to dbases (incl system dbases) via passive, then failover active to passive, and upgrade the new passive..

What about rollback.. if the first stage upgrade of the passive works, but we get dbase errors. can we rollback the upgrade on the passive, does it cause any issues with the master dbase etc..

cheers

The following Microsoft article How to: Upgrade to a Different Edition of SQL Server 2008 R2 (Setup)
details this

Microsoft Developer Network
Note
SQL Server in a clustered environment: Running edition upgrade on one of the nodes of SQL Server cluster is sufficient. This node can be either active or passive, and the engine does not bring the resources offline during the Edition Upgrade. After the edition upgrade it is required to either restart the SQL Server instance or failover to a different node.
Post #1532638
Posted Monday, January 20, 2014 8:44 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:34 AM
Points: 6,269, Visits: 13,505
Spud312R (1/20/2014)
Many thanks for this, is there a procedure if i need to rollback to std from ent editions?

Same again i believe, which would then downgrade and possibly lose features that are in use (for example aynchronous mirroring).


Spud312R (1/20/2014)
I assume the lic upgrade modifies some of the system dbases ??

Yes, so backups of the system databases would be advisable before hand


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1532696
Posted Monday, January 20, 2014 9:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 28, 2014 2:12 AM
Points: 6, Visits: 15
Cheers perry

Much appreciated...



Perry Whittle (1/20/2014)
Spud312R (1/20/2014)
Many thanks for this, is there a procedure if i need to rollback to std from ent editions?

Same again i believe, which would then downgrade and possibly lose features that are in use (for example aynchronous mirroring).


Spud312R (1/20/2014)
I assume the lic upgrade modifies some of the system dbases ??

Yes, so backups of the system databases would be advisable before hand
Post #1532715
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse