Export (0) Print
Expand All

Failover Clustering (64-bit)

SQL Server 2000

  This topic applies only to SQL Server 2000 (64-bit).

In Microsoft® SQL Server™ 2000 Enterprise Edition (64-bit), failover clustering provides high availability support. For example, during an operating system failure or a planned upgrade, you can configure one node of a failover cluster to fail over to any other node in the failover cluster configuration.

To install, configure, and maintain a failover cluster, use SQL Server Setup. As there are no previous 64-bit versions of SQL Server, you cannot upgrade an existing failover cluster to a SQL Server 2000 (64-bit) failover cluster. Also be aware that support for multiple instances of SQL Server differs in the failover clustering scenario: you can create multiple virtual servers in a cluster, but each virtual server can have only one instance of SQL Server installed.

Use failover clustering to:

  • Install SQL Server on multiple nodes in a failover cluster. You are limited only by the number of nodes supported by the operating system.

    Before installing failover clustering, you must install the Microsoft Cluster Service (MSCS) and the 64-bit versions of the Windows® Server 2003 family (additional 64-bit versions of the Windows operating system for servers will be available for later releases of SQL Server 2000 [64-bit]). Because there is no 64-bit version of Windows NT® 4.0 or Windows 2000, you cannot install SQL Server 2000 (64-bit) with Windows NT 4.0 or Windows 2000.

    To use failover clustering, you must follow specific installation steps. For more information, see Handling a Failover Cluster Installation (64-bit).

  • Specify multiple IP addresses for each virtual server.

    With SQL Server 2000 (64-bit), you can specify multiple IP addresses for each server, which allows you to use all available network IP subnets. This provides alternate ways to connect if one subnet fails, and increasing network scalability. For example, with a single network adaptor, a network failure can disrupt communications. But with multiple network cards in the server, each network can be on a different IP subnet. If one subnet fails, at least one connection can continue to function. If a router fails, MSCS continues to function, and all IP addresses still work. However, if the network card on the local computer fails, communication still may be disrupted. For more information, see Creating a Failover Cluster (64-bit).

  • Administer a failover cluster from any node in the clustered SQL Server configuration. For more information, see Creating a Failover Cluster (64-bit).

  • Allow one virtual server to fail over to any other node in the virtual server failover cluster configuration. For more information, see Creating a Failover Cluster (64-bit).

  • Add or remove nodes from the failover cluster configuration using the Setup program. For more information, see Maintaining a Failover Cluster (64-bit).

  • Reinstall or rebuild a virtual server on any node in the failover cluster without affecting the other nodes. For more information, see Maintaining a Failover Cluster (64-bit).

  • Perform full-text queries by using Microsoft Search service with failover clustering. For more information, see Using SQL Server Tools with Failover Clustering (64-bit).
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft