如何将新磁盘添加到现有SQL Server故障转移群集实例

In this article, we are going to see how to add a new disk to an existing SQL Server failover clustered instance (which I will be referring as FCI from now on). Let’s assume a scenario where you have an existing FCI with dedicated data and log drives and you want to add a new disk (Let’s say you have a new requirement to store your backups locally).

在本文中，我们将了解如何将新磁盘添加到现有SQL Server故障转移群集实例（从现在开始，我将其称为FCI）。 假设存在一个现有的FCI，其中具有专用的数据和日志驱动器，并且您想要添加新磁盘（假设您有一个新的要求，将备份存储在本地），这种情况发生。

I will be demonstrating this in my lab setup where I have a two node failover clustered SQL Server 2017 Instance, running on Windows Server 2012 R2. Below is the current state of my FCI from failover cluster manager.

我将在我的实验室设置中对此进行演示，在该实验室设置中，我有两个节点故障转移群集SQL Server 2017实例，该实例在Windows Server 2012 R2上运行。 以下是故障转移群集管理器中FCI的当前状态。

As you can see I have two disk drives (E$-SQLData and F$-SQLLogs) dedicated to my SQL Server Instance. Now I would like to add a new disk with volume label SQLBacks. First thing first, we need to carve a new disk from SAN and present it to windows (This part will be typically done by Storage admins and or Windows admins depending on your organization). FYI, in my lab environment for the demo purposes, I am leveraging windows server iSCSI for building my SAN infrastructure. In order to create a new disk drive and present to both the nodes of my failover cluster, I am going to create a new iSCSI virtual disk from my SANDC machine. This is the server which acts as Domain Controller and SAN (File and Storage Services role has already been installed and configured) in my lab environment.

如您所见，我有两个专用于我SQL Server实例的磁盘驱动器（E $ -SQLData和F $ -SQLLogs）。 现在，我想添加一个带有卷标SQLBacks的新磁盘。 首先，我们需要从SAN雕刻一个新磁盘并将其呈现给Windows（这部分通常由存储管理员和/或Windows管理员完成，具体取决于您的组织）。 仅供参考，在演示环境中，我将利用Windows Server iSCSI构建SAN基础架构。 为了创建一个新的磁盘驱动器并将其呈现给故障转移群集的两个节点，我将通过SANDC计算机创建一个新的iSCSI虚拟磁盘。 这是在我的实验室环境中充当域控制器和SAN（已安装和配置文件和存储服务角色）的服务器。

创建一个新磁盘 (Creating a new Disk