Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2005

    Unanswered: Install SQL2000 and SQL2005 in production environment?


    Is it possible to deploy both SQL2000 and SQL2005 on the same server in the production environment?

    Is it recommended? Next year we will be deploying a SQL2005 solution and was wondering if we could get away with installing it on the same server as the SQL2000 server, or whether we should put it on another server.

    We have up to a maximum of 50 concurrent users.


  2. #2
    Join Date
    Jun 2003


    SQL 2000 and SQL 2005 can install on same machine.But I wont recommend in a production server.Better install on separate server.
    I love cursor,though I never use it.Cos' I dont want to misuse it.


  3. #3
    Join Date
    Jan 2004
    In a large office with bad lighting
    Can you do it? - Sure you can.

    Should you do it? - It depends!

    It depends on resources available on the box. It depends on workload. It depends on the phase of the moon

    If you have another box to work with, say a development box, maybe install 2005 in a separate instance, then play with it to see if there any adverse effects. If not, plan for failure just in case comething goes drastically wrong. Maybe it will, probably it won't ... but it depends. I firmly believe that Murphy was an optimist

    But I would definitely install it to a separate instance in any case, on any box.

    -- This is all just a Figment of my Imagination --

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts