Results 1 to 4 of 4

Thread: Server Question

  1. #1
    Join Date
    Jul 2004
    Posts
    191

    Unanswered: Server Question

    I am trying to find a server for me to test whatever I need in SQL Server 2000

    Now I have located a machine, which has a software application on that server and SQL Server (Which no one uses). Is it possible for me to use this server for SQL purposes? Such as upgrading, reinstall etc.., would such task harm the application that is residing on that server? Or should I get a machine totally dedicated to SQL Server only?

    Please advise.

    Lystra

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Maybe.

    It depends on what else the machine is used for, because you may need to reboot, etc. If the machine is a web server, three tier app server, etc, then it would be a very poor choice for a test machine. If it simply has an application that nobody uses anymore, then it could be a great choice. I suspect that it lies somewhere in between.

    -PatP

  3. #3
    Join Date
    Jul 2004
    Posts
    191
    So it's just better to get a machine dedicated for my purposes only.

    Thanks

    Lystra

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    The best answer is usually to have a box dedicated for the purpose. That eliminates every "moving piece" that you can from the equation. Sometimes you are constrained by time/space/money so that another solution is "better" for a specific case, but the simplest and safest answer in the long term is usually to have a separate box where you won't disturb another user regardless of what you need to do.

    -PatP

Posting Permissions

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