Possible to restore SQL 2005 EE to Std? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Possible to restore SQL 2005 EE to Std?

The former DBA installed more than the licensed number of SQL Server 2005 EE SP1 and I have to get them down to Standard. No explicitly-Enterprise Edition functionality is being used.<br /><br />There are a couple hundred SQL Logins and passwords that I’d like to keep. <br /><br /><u>Anyone try this before?</u> Attach or restore Master DB from a SQL 2005 EE SP1 installation to the same in Standard Edition?<br /><br />I have my doubts, but if possible this may be a trivial exercise. It is an 8-5 shop with 400 users. I also find myself without being able get a Standard installation set up in order to test it, for a couple weeks yet. [:I]<br /><br />If I can’t keep the Logins then since I’ll be disturbing the enterprise quite a bit anyway, I’m thinking about moving to integrated security for all the apps that support it.<br /><br />Thanks for any info. [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]
You can’t restore any system database including master from one edition or build to another…
You can restore user database from SE to EE and EE to SE or from one edtion/build to another… You can use the script from the following article to move the logins… How to transfer the logins and the passwords between instances of SQL Server 2005
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

Thank you!