I have been tasked with performing an edition change from SQL Server 2005 Standard Edition to SQL Server 2005 Workgroup Edition, on Windows Server 2003 Standard Edition. Due to a previous failed attempt, I have a few questions:
-
I have backed up my databases using the
Backuptool in tasks when right clicking on a database in the server. Is this the correct approach? Or is there something I am possibly missing? -
I keep getting a warning when the installation wizard checks my system, that in order to do the edition change (I can't remember the feature of every edition of SQL Server 2005 so I'm not sure if we’re downgrading or upgrading!), I need to supply the
SKUUPGRADE=1parameter in command prompt. I type that statement (SKUUPGRADE=1) insqlcmd. I'm assuming this is wrong. Please tell me how to fix this problem, if you know. -
After that, I select the default instance then the next step in the wizard tells me there is nothing to upgrade. I can't remember the exact error, but does this mean I need to uninstall my current version of SQL Server first?
Best Answer
Standard to Workgroup is a downgrade
This is the BOL page on upgrades
Unfortunately, you'll have to uninstall and reinstall. On the bright side, the master, msdb etc will simply restore into the "lower" version as long the version number is the same.