14.6 Adding disks

14.6 Adding disks

14.6.1 adding a shared disk to a local

On the SQLSVR1 server, open the Computer Management console, and follow the steps below to add the shared disk locally.

(1) Bring the disk online

The initial state of the shared disk is "offline". Right-click on the icon for the shared disk and select "Online".

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6E/29/wKioL1V1fmmgHMt6AAM88vKzIFo786.jpg "title=" 1 Online. png "alt=" wkiol1v1fmmghmt6aam88vkzifo786.jpg "/>

(2) Initialize disk

When online, if the shared disk has not yet been partitioned, its status is displayed as "not initialized." Right-click on the icon for the shared disk and select Initialize disk.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6E/2D/wKiom1V1fQfhdZucAANKmcx9-XU827.jpg "style=" float: none; "Title=" 2 initialize. png "alt=" wkiom1v1fqfhdzucaankmcx9-xu827.jpg "/>

In the Initialize Disk dialog window, select the partition format for the disk. The default is the MBR partition form, which is the type of partition that earlier versions of Windows can recognize.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6E/29/wKioL1V1fqrD4369AAE2kcs-dxY148.jpg "style=" float: none; "Title=" 3 initialize the partition. png "alt=" wkiol1v1fqrd4369aae2kcs-dxy148.jpg "/>

(3) New Volume

If you do not create an over-the-block (or volume) on the disk, you will need to create a new partition (or volume). Usually we will create a simple volume for the shared disk.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6E/29/wKioL1V1f5vzWbfLAAOWu2_0Q8Q462.jpg "title=" 4 New Volume- 0.png "alt=" Wkiol1v1f5vzwbflaaowu2_0q8q462.jpg "/>

On the Welcome to the new Simple Volume wizard, click the Next button to continue with the following steps.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6E/2D/wKiom1V1fbOxOJgIAAGGlk5KpqM974.jpg "style=" float: none; "Title=" 4 new Volume -1.png "alt=" Wkiom1v1fboxojgiaagglk5kpqm974.jpg "/>

On the Specify Volume size page, you can specify a value for the volume of disk space that is created by default to create all of the space as a simple volume.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6E/29/wKioL1V1f1bx4gBBAAD1BqVqQRI175.jpg "style=" float: none; "Title=" 4 new Volume -2.png "alt=" Wkiol1v1f1bx4gbbaad1bqvqqri175.jpg "/>

On the Assign Drive letter and Path page, assign a drive letter to the volume.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6E/2D/wKiom1V1fbPzvu_cAAEwON7S8HY439.jpg "style=" float: none; "Title=" 4 new Volume -3.png "alt=" Wkiom1v1fbpzvu_caaewon7s8hy439.jpg "/>

On the Format Partition page, specify the format of the partition (or volume) for the volume, including the file system, allocation unit, volume label, and so on.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6E/29/wKioL1V1f1bwDe75AAGOTxq-o8c904.jpg "style=" float: none; "Title=" 4 new Volume -4.png "alt=" Wkiol1v1f1bwde75aagotxq-o8c904.jpg "/>

On the Completing the New Simple Volume Wizard page, click the Finish button to begin creating a simple volume.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6E/2D/wKiom1V1fbSQkmFmAAIMch0lIII544.jpg "style=" float: none; "Title=" 4 new Volume -5.png "alt=" Wkiom1v1fbsqkmfmaaimch0liii544.jpg "/>

(4) Confirm

After a partition (or volume) has been created, the status of the disk appears as "online" and displays information such as the drive letter, volume label, file system, and capacity of the current partition (or volume).

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6E/29/wKioL1V1gOGy9dZNAANn-rY72t0645.jpg "title=" 5 Complete the. png "alt=" wkiol1v1gogy9dznaann-ry72t0645.jpg "/>

On the SQLSVR2 or other node, open the Computer Management console, right-click the icon for the shared disk, and select online. Because shared disks have been initialized, created simple volumes, and so on in the SQLSVR1 server, there is no need to repeat these steps, and the status of the shared disks will immediately appear as "online."

14.6.2 adding disks to the cluster

On the SQLSVR1 server, open the Failover Cluster Manager console, expand the storage node in the tree-like list on the left, select disk, select Actions from the main menu, and then select Add Disk.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6E/29/wKioL1V1gkrjMWZkAAHKEszPffI797.jpg "style=" float: none; "title=" Add disk 1.png "alt=" Wkiol1v1gkrjmwzkaahkeszpffi797.jpg "/>

In the Add Disk to Cluster dialog window, all available disks that are currently recognized by Cluster Administrator are listed. Select one of the available disks and click the OK button.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6E/2D/wKiom1V1gKjxjTbFAADmADwbuKM293.jpg "style=" float: none; "title=" Add disk 2.png "alt=" Wkiom1v1gkjxjtbfaadmadwbukm293.jpg "/>

After the disk is added, information such as its status, owner node, capacity, and so on is displayed in the disk list.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6E/29/wKioL1V1gkuTyySYAALKptLBh-4639.jpg "style=" float: none; "title=" Add disk 3.png "alt=" Wkiol1v1gkutyysyaalkptlbh-4639.jpg "/>

When the shared disk is clustered, the status of the disk is displayed as "reserved."

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6E/2D/wKiom1V1gKiiJYGhAANey9u3JxE440.jpg "style=" float: none; "title=" Add disk 4-1.png "alt=" Wkiom1v1gkiijyghaaney9u3jxe440.jpg "/>

In a non-owner node, the clustered disk not only shows a status of reserved, but also a red downward arrow on the disk icon to indicate that the current node cannot use the disk. There is also an informational icon next to the status of hold that moves the mouse to the prompt icon, showing "keep (the disk is offline because of a policy set by the administrator.") If you force "online", an error message pops up, prompting the disk to be managed by the cluster.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6E/2D/wKiom1V1gSrBG0h3AAOAueT0h4c184.jpg "title=" Add disk 4-2.png "alt=" Wkiom1v1gsrbg0h3aaoauet0h4c184.jpg "/>

14.6.3 moving disks in a cluster

Open the Failover Cluster Manager console, expand the storage node in the tree-like list on the left, select disk, and then select Actions, move available storage, select nodes from the main menu.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6E/29/wKioL1V1gznQ9qanAAKrx2ejUks933.jpg "title=" Move Disk 1. PNG "alt=" wkiol1v1gznq9qanaakrx2ejuks933.jpg "/>

In the Move Available Storage dialog window, select a cluster node and you can move the current available storage from the current node to the target node.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6E/29/wKioL1V1gwCh7k7TAAD-nlKcglk889.jpg "style=" float: none; "title=" Move disk 2.png "alt=" Wkiol1v1gwch7k7taad-nlkcglk889.jpg "/>

This article from "SQLServer2014 series" blog, declined reprint!

14.6 Adding disks