SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL 2008 failover 2 node (A/P) license upgrade from STD to ENT


SQL 2008 failover 2 node (A/P) license upgrade from STD to ENT

Author
Message
Spud312R
Spud312R
Valued Member
Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)

Group: General Forum Members
Points: 62 Visits: 24
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
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)

Group: General Forum Members
Points: 52963 Visits: 17672
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" ;-)
Spud312R
Spud312R
Valued Member
Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)

Group: General Forum Members
Points: 62 Visits: 24
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.

Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)

Group: General Forum Members
Points: 52963 Visits: 17672
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" ;-)
Spud312R
Spud312R
Valued Member
Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)

Group: General Forum Members
Points: 62 Visits: 24
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

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search