Multiple Database Instances
A big enhancement new to SQL Server 2000 is the ability to run multiple instances of the SQL Server 2000 database engine on the same computer. Each instance has its own databases (system and user databases), memory pool, SQL Server Agent services, SQL Server services, network connections, registry keys associated with the SQL Server Agent, SQL Server services, or RDBMS engine, and different names. Only one copy of the client utilities is installed and can be used by the multiple instances. Applications connecting to the different instances connect using the different names assigned to each instance. In many ways, it is similar to using SQL Server 6.5 or SQL Server 7.0 on different computers. Oracle has had this feature ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
