SQL 2008 and SQL Express 2005 Coexist

I have a server running on windows 2008 with SQL 2008, for some reason I need to install the SQL express 2005 to the same server, any expert have experience about this? any risk need to bear?

thanks
LVL 6
gcl_hkAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

zadeveloperCommented:
Yea, they co-exist fine.
I have a environment running sql server 2008, express 2008 and express 2005.
Some applications require specific version of express to run (ie: SQL 2005 databases are not compatibale with Sql 2008 databases - you cannot backup a sql 2008 db and restore it directly to sql 2005 express  etc...)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Guy Hengel [angelIII / a3]Billing EngineerCommented:
yes, they can coexist with no problems.
the only setting you need to configure on both instances is the "max memory setting" to ensure they will not try to both fetch all the RAM, which would result in "paging", which would slow down both instances AND the server to almost "halting" ...
0
Reza RadConsultant, TrainerCommented:
you can do this, you can install any instance of sql server you want
but if you run under windows server 2008, so why you don't use sql server 2008 enterprise edition?, this is full feature

0
sureshchsahuCommented:
You can have as many servers  as you can installed with different versions on the same machine
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.