Workflow for a high availability (HA) configuration

You can install and configure InfoScale Storage and SQL Server in a Microsoft cluster for high availability on a single site.

Table: Process for deploying SQL Server with InfoScale Storage in a Microsoft high-availability cluster



Understand the configuration

See Planning your SQL Server high availability configuration.

Configure the storage hardware and network

  • Set up the storage hardware for a cluster environment.

  • Verify the DNS entries for the systems on which SQL will be installed.

See Configuring the storage hardware and network.

Establish a Microsoft cluster

Establish the cluster before installing InfoScale Storage.

Install InfoScale Storage with the Microsoft Failover Cluster option

Refer to the Veritas InfoScale Installation and Upgrade Guide.

Configure and manage disk groups and volumes

  • Use the VEA console to create disk groups and volumes for the application and for the quorum resource.

    See Tasks for configuring InfoScale Storage.


    Setting up a Microsoft failover cluster creates physical disk resources for all the basic disks on the shared bus. To use these disks when you create your SFW cluster disk groups, you must first remove the physical disk resources from the cluster. Otherwise, a reservation conflict occurs.

Implement a dynamic mirrored quorum resource

  • Create a dynamic cluster disk group with a mirrored volume for the quorum disks.

  • Verify that a Volume Manager Disk Group (VMDG) resource is created for the quorum disk group.

See Tasks for implementing a dynamic mirrored quorum resource.

Create the SQL virtual server resource group

  • Create a SQL Server resource group in the cluster.

  • Add the VMDG disk group resource(s).

See Creating the resource group for the SQL Server instance.

Install SQL Server

Verify the cluster configuration

Move the online SQL Server cluster group to the second node and back to the first node.

See Verifying the SQL Server group in the Microsoft cluster.