February 13, 2008 at 1:15 pm
I am hoping to be able to maintain dual installations of SQL Server 2000 and SQL Server 2005 on the same machine. Is this possible? If so, what issues should I watch out for --during the installation and after? I am a developer and do not have the luxury of having 2 different servers on which to develop. I have clients using SQL Server 2000. I have some clients that are wanting to upgrade to SQL Server 2005, thus my need to have both at my disposal for development/testing.
Any help would be appreciated!
February 13, 2008 at 1:20 pm
It is definitely possible. My work machine's set up that way.
Make sure you install SQL 2000 first (perhaps as the default instance) and then 2005 as a named
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 13, 2008 at 1:41 pm
Thanks.
Great! It's possible. That was the first hurdle. Now, can you give me any advice as to what to watch out for? That is...either during the installation of 2005 or in the process of running both? Of course I'd like to think that they will work together with no problems at all...but I'm hesitant to assume that, because you know what happens when you assume....
February 13, 2008 at 9:58 pm
The do work together pretty well.
Make sure when you install 2005 that you create a new instance and don't upgrade the 2000 instance.
I would recommend setting the max memory for both, so that neither one can hog all the memory on the box. Assuming that there's only the 2 sql instances, leave some memory for the OS, then divide the rest between the two instances.
You can upgrade databases from SQL 2000 to 2005 very easily. It is impossible to downgrade them again.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 14, 2008 at 8:01 am
Thanks. I appreciate the advice.
If anyone else has anything else to add.....I'd be most grateful!
February 15, 2008 at 2:34 am
This will also work if SQL Server 2005 is installed first as the default instance followed by SQL Server 2000 as a named instance. ...at least it worked OK for me.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply