Post reply

SQL 2000 and SQL 2008 R2 on same server

  • March 29, 2011 at 11:54 am

    #237555

    Can SQL 2000 and SQL 2008 R2 reside on the same server?

    I have installed SQL 2008 R2 on a Windows 2008 server. Now the users want their 2000 database on the same server. I will install on a new instance to keep it separate. Is there anything else that I need to be aware of before I proceed to do this? and is it even possible? Upgrading the database to 2008 is not an option right now as we wait for the applicaiton to support it.

    Thanks.

    Patti

  • March 29, 2011 at 12:28 pm

    #1305080

    Yes, this configuration is supported. See:

    http://msdn.microsoft.com/en-us/library/ms143694.aspx

  • March 29, 2011 at 12:34 pm

    #1305087

    Yes, they can run side-by-side. On my old desktop I had 2000, 2005, 2008 and 2008 R2 all running at once.

    But, on a real server, with real users, they won't play well together. You will be looking at CPU contention. You should cap each one's memory lest they start fighting with each other. It might be something to do short-term (although I'd hesitate to do that), but it is certainly not something to do long term.

    ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

  • March 29, 2011 at 1:21 pm

    #1305112

    Thank you very much for responding.

    I had posted on the SQL 2000 forum a question regarding memory configuration with 2 instances of sql 2000 in a server. No one has responded though. I was trying to figure out if what was setup was correct. 🙁

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply