This article is not part of the System Center Cloud series but we will use the final product to host System Center database instances.

Configure storage

We somehow need to configure path to the cluster disks where SQL server instances will store the data. We can assign drive letter to each disk or we can assign mount point. If you are absolutely sure that you will not need more disks then the amount of drive letters available then you can assign drive letters. In the production environment you can usually see that the disks are targeted by mount points. Mount points are handy in the production environment because you usually do not know how many disks you will have in the future.

Assign drive letters

  • Failover Cluster Manager - Change Drive letter
  • Select a new drive letter

Add Mount Points

Create a small disk for mount points

  • First we will need a small cluster disks for the mount point.
  • 100 MB is enough but you will have to use MBR. Create larger disk if you require GPT (1GB for example).
  • Create another disk for cluster.
    • PowerShell
New-VHD -Path 'C:\ClusterStorage\Volume1\contsqlfcic0\Virtual Hard Disks\shared-mountpoint-sccm.vhdx' -Dynamic -SizeBytes 1GB
Add-VMHardDiskDrive  -VMName contsqlfcic0n0 -Path "C:\ClusterStorage\Volume1\contsqlfcic0\Virtual Hard Disks\shared-mountpoint-sccm.vhdx" -ShareVirtualDisk
Add-VMHardDiskDrive -VMName contsqlfcic0n1 -Path "C:\ClusterStorage\Volume1\contsqlfcic0\Virtual Hard Disks\shared-mountpoint-sccm.vhdx" -ShareVirtualDisk
  • Online disks on all nodes, initialize and format (NTFS) on one node.
  • Add Disks to a Cluster
  • Assign a drive letter. I will assign M drive letter in the Failover Cluster Manager.

Create Mount Points

  • Create mount point in the Disk Management (diskmgmt.msc).
  • Change Drive Letter and Paths...
  • Create new folder on the new disk for the new mount point.
  • In the production environment you should set descriptive names. For example: <Name of the instance>_TempDB_Log

Configure dependencies in the Failover Cluster Manager

  • I will guide you how to configure dependencies after installation of the first clustered SQL instance.
« Previous Next »

Part of the series

  1. Building guest (virtual) Failover Cluster on Hyper-V host with Windows Server 2012 R2 - Part 1 - Create virtual machines
  2. Building guest (virtual) Failover Cluster on Hyper-V host with Windows Server 2012 R2 - Part 2 - Install and configure cluster
  3. Building Microsoft SQL Server AlwaysOn Failover Cluster Instances - Part 1 - Design
  4. Building Microsoft SQL Server AlwaysOn Failover Cluster Instances - Part 2 - Distributed Transaction Coordinator (MSDTC)
  5. Building Microsoft SQL Server AlwaysOn Failover Cluster Instances - Part 4 - Install first node
  6. Building Microsoft SQL Server AlwaysOn Failover Cluster Instances - Part 5 - Install second node
  7. Building Microsoft SQL Server AlwaysOn Failover Cluster Instances - Part 6 - Install another instance
  8. Building Microsoft SQL Server AlwaysOn Failover Cluster Instances - Part 7 - Manually configure Reporting Services