I have a cluster DB, and i am trying to attach DB files, it doesn't let me navigate to any other drive except for DB? Is there something wrong that i am doing?
Example, if my DB is created in F:\, i am allowed to attach only to mdf files from F:\
[EDIT/ SOLUTION]
I found the solution on my own, I will need to add another storage to the cluster, if it is a mount point then assign a drive letter, and add dependency on the cluster resource, this would then allow me to attach to the DB as the drive letter is visible in the sql server management studio
Best Answer
In Windows Failover Clustering an SQL Server instance is one part of a Resource Group. A Resource Group also contains disks for the SQL Server installation and data files.
You will only be able see and add data files to/for drives that exist as part of the same Resource Group within a SQL Server instance.
If you need to add more disks the cluster administrator can do this for you or see http://technet.microsoft.com/en-us/library/ff182326(v=ws.10).aspx.
Hope that helps.