SQL Server Performance Forum – Threads Archive
SQL Cluster does not recoqnize new SAN DriveHi everyone ! Does anyone ever experience this and know how to solve it? We added new SAN drive and designated the drive letter L: The windows 2000 server operating system recognize that new drive letter L:, but when I go to SQL Enterprise manager, trying to create new database using disk space on L:, that drive letter L: cannot be seen? SQL Enterprise Manager only displayed existing drives which is G: , H: and K:. On the windows explorer, it shows G: , H: and K: and L:. We are on SQL Cluster with 2 nodes. I am not sure if this problem relate to clustering or could be just the way SAN drives interact with SQL Server. Any ideas will certainly greatly appreciated. Thanks!
Have you added the new drive as a SQL Server cluster resource? If not, you need to. —————————–
Brad M. McGehee, MVP
Yes add the disk as a dependency to the "SQL Server" resource in the cluster administrator.
Brad, Argyle, Thank you very much for the input. I appreciate it. That’s make sense. Last year, when we replaced server hardware on one node , we didn’t have the problem, because SQL cluster has been configured to use existing 3 local drives. This time is a new drive, so have to be configured on Cluster Admin. Both of you have a great day!