Could SQL server 2008 R2 instance “sustain” OS upgrade from Standard to Enterprise?
Has anybody ever faced such issue – a necessity to upgrade Win2K8 R2 server from Standard to Enterprise while keeping the installed instance of SQL Server “untouched”? What we have is SQL Server 2008 R2 Enterprise edition installed on top of Win2K8 R2 server (Standard). Currently the SQL database is limited to 32GB of RAM due to licensing constraints, and we need to upgrade the server to 2008 R2 Enterprise to triple the memory space. Is it possible to perform such upgrade without rebuilding the SQL installation from scratch – as far as it’s production environment we’re really limited in possibilities to downtime the SQL server running? Thanks in advance
Are you going to do an [online upgrade] of the edition, or use media disk instead? Not that I have tried it, but just thinking about it I would not think it would harm the SQL Server installation. Going from Standard to Enterprise for the OS should just be OS files and registry values. I would not think it would touch any of the binaries for SQL Server. If you have somewhere you can install a virtual machine, try it out first. Before I go do this on production I would have my information handy to open up a support ticket with Microsoft incase something does not come back up. It is a supported path to take, the only thing Microsoft states is you cannot upgrade a domain controller from Standard to higher edition without first demoting the DC. :