Saturday, January 05, 2013

How to add SAN Drives as SQL Resources / My Computer


How to add SAN Drives as SQL Resources / My Computer:

If your server has be allotted with new SAN drive, and which is not visible in My Computer and you are not able to perform any action on this drive please follow the given instructions.

1.       Once the SAN Drive is allotted to your server.
2.       First make Drive online using Disk Management utility
             
3.       Then format the Drive and allot Drive Letter.
4.       Then Open your FailOver Clustor Manager, and add a Disk as shown in below image

5.       Once a Disk is added to Storage, Select your server name and from Other Resources select SQL Server and right click to select Properties
       
6.       Then from Properties select Dependencies tab
       
7.       Insert required Drive using Insert Button
8.       Dependency Report can be seen as per below steps
       
9.       Finally your drive will be visible in My Computer.

2 comments:

Yogesh Deshmukh said...

i have problem with "Step 3" without format can we add that SAN drive

Unknown said...

Dear Yogesh,
I am not sure whether it is mandatory step or not, but i feel its better to use disk after formatting.