Downgrading from Enterprise edition to Standard Edition

  • What is the least painful way to downgrade from enterprise edition to standard? It appears nearly all of our servers have enterprise edition when then don't really need it. And with licensing costs being what they are, the savings could be substantial. Is a backup of the dbs, uninstall enterprise and an install of standard edition the only way to go? TIA.


    Terry

  • Hi Terry,

    Have you found solution?  I have the same problem.

     

    Thanks,

    ken

     

     

  • As the first post: there is no direct downgrade path

    Backup user dbs, remove sql, install SQL, restore user dbs.

    Not sure if restoring the system dbs is recommeded, but script all jobs, logins, operators etc first to reproduce them

  • This seems to be a common problem. I don't really trust uninstall programs. Does anyone know a sure way to clean up all files installed, registry settings etc from enterprise 2000? You should be able to just detach your databases, store them in a different directory and then re attach after standard 2000 installation?

     

    Mark.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply