Enterprise and Standard SS 2000 on the same box? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Enterprise and Standard SS 2000 on the same box?

We have a SQL Server 2000 Enterprises Edition installation on a server which uses log shipping to backup some databases. We have another application that we do not want to log ship for backup. Apparently, if we run this application under SQL Server 2000 Standard Edition we can save liscensing costs. Is it possible to run SQL Server Enterprise and SQL Server Standard on the same box? Thanks folks,

I think you can’t have two diffrent installation of SQL Services on same box.
Whereas you can have multiple instances of one Services on same box in Enterprise Edition.
Yes, in differents instances.
Luis Martin
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.
Yes, you can have only one default instance and 16 names instances irrespective of editions. ENsure the server is equipped with resources such as memory, cpu and other aspects. We have similar service that has 2 different editions to handle the application with no issues. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.