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 to downgrade a SQL Server running SQL Server 2008 R2 Standard Edition SP1 to 2008 R2 Web Edition SP1.

I discovered this question on Server Fault:

Can I downgrade SQL Server 2008 R2 Standard To Web Edition?

Which links to a similar scenario:

Downgrading from SQL Server 2008 R2 Enterprise Edition (trial) to R2 Web Edition (licensed)

This server doesn't have Analysis Services installed and I tried to run the Edition "Upgrade" tool and got this failure:

I checked the detailed report and all that it says is:

Rule Name: EditionUpgradeMatrixCheck
Rule Description: Checks whether the selected instance of SQL Server meets upgrade matrix requirements.
Result: Failed
Message/Corrective Action: The selected SQL Server instance does not meet upgrade matrix requirements.

Strangely the Edition Downgrade rule has passed.

I ran this from the SQL 2008 R2 Web Edition DVD.

Can anyone guide me through downgrading this SQL server to Web Edition, I am now at a loss.

share|improve this question
add comment

1 Answer 1

up vote 3 down vote accepted

Unfortunately looking at the MS matrix you cannot do this. You were able to earlier because evaluation versions don't have that lock, but once you go full edition it's locked out

http://msdn.microsoft.com/en-us/library/ms143393%28v=sql.105%29.aspx

You could try an approach taken here but proceed with extreme caution. http://skreebydba.com/2012/11/16/downgrading-sql-server-enterprise-to-standard-with-scripts/

[edit]: This URL has the scripts to recreate logins, etc. that Aaron pointed out Just a headsup though, this doesn't script out jobs. If you restore MSDB to recreate jobs, make sure to

UPDATE MSDB..SysJobs 
SET Originating_Server = 'SQLServerName'

It will also work for downgrades to web.

share|improve this answer
    
That's pretty much the conclusion I was coming to. I was hoping to avoid having to uninstall Standard then re-install Web Edition. Thanks for confirming this. –  Kev Dec 11 '12 at 22:40
    
My pleasure, sorry to hear you gotta go through that hassle. –  Ali Razeghi Dec 11 '12 at 22:44
    
Uninstalling and reinstalling shouldn't be all that painful. Just take backups of all your databases first (and script out logins / jobs etc). –  Aaron Bertrand Dec 11 '12 at 23:30
add comment

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.