Thursday, May 30, 2013

Drive not showing in SQL Server Cluster?

I've had this happen a couple times, yesterday being the most recent, so this post will also serve as a reminder next time I run into this situation.

Say you have a cluster and you add a new drive/LUN.  Your storage folks tell you it's available and it's been added in as a clustered resource.  All is good, right?  Nope.

What you will notice is that if you try to backup to, restore from, or basically access that drive in any way from SSMS, it will not be listed as an available drive.  Why?

The last thing you need to be sure to do when you add a clustered resource is to make sure it's also added as a dependency to your SQL Server service:

  • Open your Cluster Manager
  • Expand Services and applications
  • Click on SQL Server (instance name)
  • Go to "Other Resources" section
  • Right-click on SQL Server (instance name) and click Properties
  • Go to the Dependencies tab
  • Insert the newly added drive as a dependency
Now if you go to access that drive from SSMS, for example, you will see it available.