[Last Call] Learn how to a build a cloud-first strategyRegister Now


What is the best way to downgrade SQL Server 2005 Enterprise Edition to Standard Edition?

Posted on 2007-10-16
Medium Priority
Last Modified: 2012-06-21
Hi all--I'm looking for the cleanest way to downgrade a SQL Server 2005 Enterprise Edition SP2 to Standard Edition.  Is it possible to do this downgrade without actually uninstalling and reinstalling?

Note: I've been finding a reference or two on Google to two stored procedures which don't seem to be documented:


They aren't part of the master or msdb databases, so I'm wondering if they're tools found elsewhere.  Where can I find more information on how to load and execute them?

Question by:jkv10
  • 2
LVL 18

Accepted Solution

Yveau earned 375 total points
ID: 20089661
... never heard of those procs ...

I would go for reinstalling.
Make sure to detach databases first, so you can attach them once the reinstall completes.
... or take backups.

Hope this helps ...
LVL 18

Expert Comment

ID: 20096045
Glad I could be of any help ... sorry there is no easy way to go ...

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question