2008 SQL Server, attach option does not show all the drive letters

Question

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

Has either of these responses answered your question. Other can we have more information maybe a screenshot from you cluster administrator. — Bernie White, Nov 04 '12 at 19:14
Nop, 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 microsoft sql server studio — Nida Sahar, Nov 04 '12 at 19:20
If you could add that as an answer and close the question that would be great. — Bernie White, Nov 04 '12 at 19:21

score 1 · Answer 1 · answered Oct 22 '12 at 08:30

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.

score 0 · Answer 2 · answered Oct 22 '12 at 08:02

0

Is the other drive a local drive on one of the nodes? If so, you can't use that for storing a clustered DB because in the event of a failover the new owner won't be able to bring the database back online.

The storage for your databases needs to be a target visible to all the nodes in the cluster, and also needs to be part of the failover group that holds your SQL instance.

answered Oct 22 '12 at 08:02

Chris McKeown

7,168
1
18
26

The local drive is present on the both the nodes – Nida Sahar Oct 27 '12 at 18:20
And is it part of the cluster resource group that holds the SQL instance? – Chris McKeown Oct 28 '12 at 12:10

score 0 · Accepted Answer · answered Nov 04 '12 at 19:24

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

2008 SQL Server, attach option does not show all the drive letters

3 Answers3