There is a request from DBA team to add one disks from storage and assign to MS SQL 2008 server. I have created a iSCSCi LUN and mount it to the server. Now we can able to see the newly created disk in Server.
After some time DB admin called me and said they cannot see that newly created disks in SQL Management studio while they try to take a backup of one particular database. Here is the screenshot. I have mount the drive as U but it wasn’t showing in SQL backup windows.
Ok, Need to troubleshoot further. MS SQL servers are configured in Cluster. I went to Server manager–> Features–> Failover cluster manager–> Storage–> Right click–> Add disk
Once we add we can see it this disks in Available storage area. Now we need to move this disk in to cluter resource. In this case SQL Server ( MS SQL SERVER) is the service resource
Could able to see this disks in SQL server cluster resource
Not yet done. still need to add some more steps to show this disks in to SQL Management studio backup screen
Go to Fail over cluster manager –> serives and applications–> SQL Server–> Other resources–> SQL Server –> Right click–> Properties
Select the dependencies tab–> select the disk and click insert
That’s it. Now we can see this disks in cluster as well as in backup windows
Here is my U drive and DBA team is happy. Thanks for Rafeeq to assist us to troublehoot this.