DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Multiple instances of SQL 2000

  1. #1
    Terry Guest

    Multiple instances of SQL 2000


    What are a few reasons that one might want to run multiple instances of SQL
    2000 on the same server?

  2. #2
    Q*bert Guest

    Re: Multiple instances of SQL 2000


    This microsoft doc may help.
    http://msdn.microsoft.com/library/de...rarch_0cfo.asp

    Off the top of my head I could think of two or three reasons...

    1) Reached maximum number of database objects supported by a sql server.
    The load to each database is VERY small but all may be needed at any 1 time
    No reason to spend more $'s if the machine can support additional db's
    2) Have service that your not worried about crashing Service, not hardware
    for development or testing.
    3) Something to do with an additional level of security. Alternate SA Pwds
    etc.


    "Terry" <snakbrat@yahoo.com> wrote:
    >
    >What are a few reasons that one might want to run multiple instances of

    SQL
    >2000 on the same server?



  3. #3
    Daniel Reber Guest

    Re: Multiple instances of SQL 2000

    If you are short on cash then the main instance can be your production
    server and the named instances can be your test servers.

    Daniel Reber
    Datamasters, Inc


    "Terry" <snakbrat@yahoo.com> wrote in message
    news:3e79cf16$1@tnews.web.devx.com...
    >
    > What are a few reasons that one might want to run multiple instances of

    SQL
    > 2000 on the same server?




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center