Installing a Named Instance
New for SQL Server 2000 is the capability to run more than one instance per server. Each instance has its own separate copy of the SQL Server installation files, its own system databases, and its own user databases. Microsoft supports 16 named instances per server.
Each server can have one default database, which is referenced by the server name as in previous installations of SQL Server. The default database can be version 6.5, 7.0, or SQL Server 2000. If the default is version 6.5, you must switch between the 6.5 database and SQL Server 2000 using the v-switch command-line utility. SQL 7.0 installations can function as the default database without switching. Named instances must be SQL Server 2000.
Each subsequent ...
Get Microsoft® SQL Server™ 2000 Unleashed, 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.
