SQL-Cluster Add Disk from Cluster Configuration
Permissions:->..
To add or remove drives from cluster you must have local admin rights on the server.
The drive added by windows admin should be visible in My Computer as below.
Also should be visible in Windows Failover Cluster Manger in "Available Storage" Section in
Cluster Summary as Below
Right Click on SQL Server Service and select "Add Storage"
It will open
the window as below
One you click
OK, it will be visible in SQL server services resources windows
But it is still not used by SQL server services which can be checked by method mentioned in step 2.
In failover cluster manager, click on more actions in Actions pane in right side. It will display ‘Show Dependency Report’, click on it
Navigate to SQL Server service, Right Click on it and select properties&Now go in dependencies tab
As per above screen, there is no Drive 7 (i.e DriveK) is
available as dependency.
So add the new drive as “AND” dependent as shown below
Click Apply, Ok
And then check Dependency report again, where Drive 7 is no
longer floating in the air.
Note: To verify that the Drive
is added successfully to SQL Server Instance from SSMS try to access the Drive from SSMS.
For example, take a backup of one of the Databases and look for $K to place the backup, which is not visible in SSMS (But is visible from My Computer) before adding dependency
