![]() ![]() In the below screenshot, you can see I have selected the disks. In the below screenshot, click add storage option Select "Add storage" and the tool will prompt all the new available disks from storage. Right click on the SQL Server Service on the left-hand side of the Cluster Administrator tool. We now have to add the disks we will be going to use for the SQL cluster. We are done with only adding disks in the Windows cluster. How to Add a Disk to a SQL Server Cluster Service In the below screenshot, the tool shows disks in the available storage ![]() We can also see this disks available from my computer. Now the disks are added to available storage pool in cluster manager console. In the below screenshot, I have added all disks to the cluster. Select the disk or disks that you want to add and click OK. The tool will prompt for all the available disks that can be added to cluster. In the below screenshot, select storage, right click, and select "add a disk." Right click the storage in the console tree on the left-hand side of the Cluster Administrator tool. In the below screenshot, Disks are assigned with letters O, P, and R.Ĭlick on "Start," "All Programs," "Administrative Tools," "Cluster Administrator" to open the Cluster Administrator. Click "File," "Open Connection," enter a cluster name and click "OK" to connect the cluster. Right-click the unallocated space on the disk you wish to add on the bottom-right pane of the disk management console, and click "New Partition."Ĭlick "Next," choose "Primary Partition" and click "Next." In the partition size field, choose all the unallocated space and click "Next." Choose to format the drive as "NTFS," enter a name for the volume (or accept the default), and then click "Next" and "Finish." In the below screenshot, Disk 15 is initialized and brought online. ![]() I'm bringing the disks online on Node1 only, as we are going to use these disks for our failover cluster. Now click "Initialize." This writes a signature to the disk drive and changes the status to "Basic" and "Unallocated." Right-click the Disk, (Disk15 and Disk16) which are the disks we wish to add on the bottom-right pane of the disk management console. In the below screenshot, the new disks, 15 and 16, are shown as "Unknown" and "Not Initialized." You will see your new drive listed as "Unknown" and "Not Initialized." Right-click on "Disk Management" and click "Rescan Disks." The disk management console will look for newly attached disks and display them in the bottom-right pane. Right-click on "My Computer" and click "Manage." Expand computer management (local) and then storage. T here is no downtime required to perform this activity there is no service disruption and zero downtime. This article will show how to add a new disks to the SQL Server cluster. I have a SQL Server Cluster, with two nodes already set up, and the disks are been presented to each node. The below procedure is also applicable for a SQL Server cluster installed on Windows 2008 R2. I already have a two node SQL Server 2008 R2 Enterprise Edition cluster installed on W indows 2008 Enterprise Edition. In this post I will show a procedure to add a new disk or drive to a SQL Server failover cluster. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |