Adding a LUN to an existing SQL 2008 cluster
Hi All,
Yesterday I had to add a LUN to an existing SQL cluster. Child's play you say. Not so. The process is pretty simple.
1. Expose the LUN to each cluster server
2. Make sure it shows up in Disk Management
3. Add it as a storage resource in the Failover Cluster Manager
4. Add the storage resource to the SQL cluster
Now this last step I didn't know about - In order for the SQL server to see the new drive as a location you need to:
5. Add the new storage resources as dependencies in the SQL Server service in Failover Manager
This is actually kinda hard to find - Expand the SQL cluster in the Applications and Services item in Failover Manager. Then look at the bottom of the panel below the network section, drives section and everything else - You should see the SQL Server and SQL Agent services listed there.
Right click on SQL Server and there is your dependencies tab with the existing drives already listed there - Add the new drives.
Who woulda thunk it was so convoluted.
Have A Great Day -
Shaun