Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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 Backup tool 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=1 parameter in command prompt. I type that statement (SKUUPGRADE=1) in 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?

share|improve this question

migrated from stackoverflow.com Jan 21 '12 at 15:03

This question came from our site for professional and enthusiast programmers.

add comment

1 Answer 1

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.