Thursday, December 06, 2012 4:59 AM
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?
- Moved by Kalman TothMicrosoft Community Contributor Thursday, December 06, 2012 3:41 PM Not a Database Design question. (From:Database Design)
Thursday, December 06, 2012 5:50 AM
>>>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?
What does the below return?
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
Monday, December 10, 2012 3:10 PMModerator
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
- Marked As Answer by Allen Li - MSFTModerator Monday, December 24, 2012 3:02 AM
Monday, December 10, 2012 11:01 PM
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...