SQL Server Performance Forum – Threads Archive

Standard and Enterprise Editions

We are currently running SQL Server Enterprise Edition on our development server and are planning on replacing it with Standard Edition of SQL Server. Are we going to be able to attach the databases after reinstalling Standard Edition? Are the databases going to be functioning ok? Any potential problems that we may be encountering? Thanks for your help.

Check : http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=6335 Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

That’s not an answer to your question, but since you are going to switch from EE to SE, you might also want to consider a new edition of SQL Server – SQL Server 2000 Workgroup Edition. Choosing an Edition of SQL Server 2000 — Rediscover the web
http://www.mozilla.org/firefox/

Well, to be specific, check differents between capabilities EE vs SE, and if you are not using any aditional capabitily of EE, then there is no problem to attach. Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

You may lose out many advantages of EE such as extended memory more than 2GB, indexed views, and others as mentioned in the books online under Editions of SQL server –> Featured supported systems. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>