January 17, 2014 at 8:29 am
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
January 17, 2014 at 9:26 am
Spud312R (1/17/2014)
We have a 2 node STD sql 2008 sql failover cluster running A/P modeWe 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
NoteSQL 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" 😉
January 20, 2014 at 7:34 am
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 modeWe 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
NoteSQL 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.
January 20, 2014 at 8:44 am
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" 😉
January 20, 2014 at 9:09 am
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply