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

  • 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

  • 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" 😉

  • 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.

  • 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" 😉

  • 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