February 12, 2009 at 8:50 am
I've been reading about installing SQL 2005 onto the same server where SQL 2000 exists. I plan to install SQL 2005 as a separate instance to slowly move the 2000 databases over. From what I've been reading, I shouldn't have any problems running both versions on the same server (yes, I am running SQL 2000 SP4). Will this affect my DTS packages that I'm currently using on my SQL 2000 DBs?
Thanks,
Dave
February 12, 2009 at 2:40 pm
sql2000 and sql2005 will co exist quite happily
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 12, 2009 at 5:06 pm
Yes, SQL 2000 and 2005 can run on the same machine. Keep in mind that the 2 instances will be sharing resources so if you have your 2000 instance memory set to consume most of the memory on the box this will have to be changed.
February 12, 2009 at 5:11 pm
Definitely specifically limit memory for each instance. The resource issues are your biggest ones. We did this here at SSC and it worked fine.
Also be aware that one of these is a named instance, so be sure your applications support named instances.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply