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 (
sqlcmd. 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?