Previous Topic

Next Topic

Book Contents

Book Index

Microsoft SQL (MSSQL) Server

When MSSQL is installed on a cluster, the software binaries of the product are placed on the local drives of each one of the selected nodes and the data files are placed on the assigned disk resource on the shared drive.

The MSSQL Server services (one service is created on each cluster node) are named by default as the virtual server name. When the MSSQL resource group is moved from one node to another, the MSSQL services are stopped on the original (primary) node and started on the alternate node.

In addition to the MSSQL services resources, installation of MSSQL Server on a Windows cluster automatically creates the network name and IP address resources in the selected resource group. At that point, the MSSQL resource group becomes a virtual server and can be accessed by client applications using the virtual name.

For more information about MSSQL Server on Windows, see:http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=75566f16-627d-4dd3-97cb-83909d3c722b

Parent Topic

Database components cluster configuration