June 10, 2010 at 9:36 am
Simply put, can I install SQL2008 on a server that has SQL2005 and have them both co-exist on the same server?
We are migrating to SQL2008, but we have some licenced software where the highest SQL level is 2005. We would like to proceed without finding another server, but do not want to undermine the existing 2005 environment and DBs.
June 10, 2010 at 12:38 pm
I do this all the time on my local machines, laptop, workstation, etc., with no issues. I would not suggest you do this on a production system though. Installing & uninstalling & sharing resources on my machine is different than the machine that is holding the company's money. You know?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 10, 2010 at 1:15 pm
Yes you can have both on the same box. I currently have 2000, 2005, and 2008 on the same machine.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 10, 2010 at 1:25 pm
I encountered a case where you can't, but it's probably not your situation. I found that I was not able to install 2008 Developer Edition on a test machine that happened to already have 2005 Express Edition installed; I can't find the link now, but at the time I had found a Microsoft site that did state that an old Express install does interfere with more functional new editions. Completely uninstalling Express allowed installation of the 2008 Developer edition.
June 10, 2010 at 1:39 pm
You can do it, but be careful. You likely want to set the max memory for each instance, and you are competing for resources. So it's not as simple as installing 2008 and moving some databases from 2005 and balancing the load. You might need to add memory or something else.
You need a separate license here as well, perhaps an exception for Enterprise Edition, but I would believe that at Standard edition you'd need to license each version for your server.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply