August 3, 2009 at 11:36 pm
Hi,
We have SQL Server 2005 Enterprise edition and it is running in production. Now we got a requirement to install another instance of SQL Server 2005 Standard Edition on the same server.
Is installing SQL Server 2005 Enterprise edtion and Standard edition on same Server is supported by MS? If yes, please take me that link..
Thank You
August 3, 2009 at 11:56 pm
Hi Madhu,
I think MS supports both enterprise and standard on a single server if your software is legally purchased. But when you have enterprise edition why do you want purchase another standard edition when you can install another named instance(I think you have to purchase additional license for this). Why dont you call MS and ask them directly. I think they will be able to help you to clarify all your doubts.
[font="Verdana"]Thanks
Chandra Mohan[/font]
August 4, 2009 at 11:46 am
Hi all,
Is installing SQL Server 2005 Enterprise edtion and Standard edition on same Server is supported by MS? If yes, please take me that link
Thanks
August 4, 2009 at 2:44 pm
Go through this thread.
SQL DBA.
August 4, 2009 at 4:10 pm
Thanks Sanjay,
Could you please take me to BOL link?
August 4, 2009 at 8:19 pm
If you are already licensed for Enterprise Edition on that server - you can install as many instances as you want running Enterprise Edition. There is no additional cost or licensing to install another instance.
With that in mind - why would anyone purchase Standard Edition and install it on the same server? Just install another instance running Enterprise Edition and live with the additional capabilities that the new systems doesn't really need. 😀
You can start at the document here: http://www.microsoft.com/sqlserver/2005/en/us/special-considerations.aspx
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 4, 2009 at 10:25 pm
thank you Jeffrey,
the reason to install Standard edition is "We have Log shipping configuration setup between 2 SQL server 2005 Enterprise editions.
Primary: SQL Server 2005 EE and Secondary: SQL Server 2005 EE
Now we want to Log ship a new SQL Server 2005 standard Edition instance Databases to Existing Secondary instance which is Enterprise Edition.
So I'm not sure whether we can Configure log shipping between Standard and Enterprise edition and want to install another separate Standard edition and configure log shipping between new Primary standard edition & Secondary standard edition.
If Configuring log shipping between Standard and Enterprise edition supports, then I will use the same Enterprise edition as secondary instance for this new standard edition instance (primary) databases too.
Is Configuring log shipping between Standard and Enterprise edition supported? please confirm and take me to the MS link....
August 4, 2009 at 10:46 pm
This is where I would start when setting up log shipping: http://msdn.microsoft.com/en-us/library/ms188698(SQL.90).aspx
Since I do not use it and instead have setup database mirroring - I really cannot say for sure. However, I do know that with database mirroring you can mirror between different editions as long as both are the same version (e.g. both are 2005 or both are 2008).
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply