IT Infrastructure blog

July 14, 2011

Cannot see newly added disks in MS SQL cluster

Filed under: MS Cluster,MS SQL Server — Akther @ 2:55 pm

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.

Blog at WordPress.com.