Creating the resource group for the SQL Server instance
Prev Installing SQL Server and configuring resources Next

Creating the resource group for the SQL Server instance

Before installing SQL Server you must:

SQL virtual server installation requires a separate volume on which the system database files will be placed. Before installation, you create a Volume Manager Disk Group resource for the disk group that contains this volume. Creating this resource will enable SQL to monitor the system database files.

If you created additional SFW disk groups for SQL Server, for example, for user databases, you add Volume Manager Disk Group resources for those as well.

SQL Server installation adds the required SQL Server resources to the resource group and sets the appropriate dependencies for them.

Note:

Before creating the resource, start the cluster service on all the nodes in the cluster.

To create the SQL Server resource group and add a disk group resource

  1. From the Start menu (the Start screen on Windows 2012 operating systems), click Administrative Tools.

    Launch the Failover Cluster Manager snap-in by clicking Failover Cluster Manager.

    Ensure you are connected to the required cluster.

  2. In the left pane, right-click Services and Applications and select More Actions > Create Empty Service or Application. An empty group named New service or application is created. Right-click it and rename it, for example, SQL_GROUP.
  3. In the left pane, right-click the group you created and select Add a resource > More resources > Add Volume Manager Disk Group.
  4. In the center panel under Disk Drives, double-click New Volume Manager Disk Group to open its Properties dialog box.
  5. On the General tab of the Properties dialog box, type a name for the resource.

    For example, type SQL_DG_RES.

  6. On the Properties tab, in the Disk Group Name field, type the exact name of the disk group you previously created for the application (for example, INST1_DG), and click OK to close the dialog box.
  7. Right-click the newly named resource and select Bring this resource online.
Prev Up Next
Tasks for installing and configuring SQL Server Home Prerequisites for installing SQL Server