Downgrade SQL 2008 R2 Enterprise Cluster to SQL 2008 R2 Standard Cluster RRS feed

  • Question

  • Hi

    While I found several information about Downgrading an 2008 R2 Enterprise to 2008 R2 Standard edition (even here in this forum) I didn't found much information doing this when it's a clustered SQL Server. Is there anything I've to be aware of? My solution I've in mind is:

    1.) Stop SQL Service
    2.) Move all database (users and system) to another location
    3.) Uninstall existing Enterprise nodes/instances of both servers
    4.) Install the SQL 2008 R2 Standard on both nodes. Use same folders for databases as in the original installation. Use also all other configs as the original one (instance/cluster name, network ressource name,...)
    5.) Stop SQL Service
    6.) Remove original user and system databases back to their original folder. Replace system databases of new installation with the original ones.

    Should this work or not?

    • Edited by JohnBaumg Thursday, March 13, 2014 2:51 PM
    Thursday, March 13, 2014 2:50 PM