Adding a drive to existing SQL 2005 cluster

Question

Hi guys,

I have an existing SQL 2005 2 node cluster.

I currently have disk resource (Drive T:) on my cluster used for SQL databases. I plan to add another drive (S:) for SQL Logs. I have prepared the LUN and is seen on the cluster disk resource. However I can see it whenever I manage my SQL server via Management Studio.

Are there any more steps that I should take in order for my SQL server to use this new drive?

Thank you!

Answer 1

>>>However I can see it whenever I manage my SQL server via Management 

You meant you cannot see, right? Have you set dependencies for the new disk resource?

http://msdn.microsoft.com/en-us/library/ms177447.aspx

What does the below return?

select * from sys.dm_io_cluster_shared_drives

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance

Answer 2

A Clustered SQL Instance must have dependencies set in order to use clustered storage.  If you look at the SQL Engine object in the Failover Cluster Manager, you will see it is dependent on each existing disk drive.  Simply add the new drive to the dependency list (you may have to stop SQL depending on the OS version) and you can store SQL Database files on it.

---

Geoff N. Hiten Principal Consultant Microsoft SQL Server MVP

Answer 3

Make sure your iscsci connections are good and able to reconnect with server. Add this new disk from sql server manager>> storage>>disk management>>

Make sure it is online on the active node...

Check from passive node>> make a fail over and see is it able to get the disk online..

Then you will able to use it...

Thanks

Kumar