Can't see new drive

[l310564]

Hi,

I have been using SQL 2000 for some time with the data files stored on the C drive. Due to space considerations I bought a new drive (D) and installed it. Everything is working fine in the fact that i can see,store,delete etc.. files on the new drive but sql 2000 doesn't reconise it is there. Does anyone have any idea why? I have give the administrator account which is what sql uses all rights to the drive but to no effect.

Cheers,

Hugh

 

[ptheriault]

Is this drive internal or exteranl? What kind of drive is it?


- Paul
- Database performance looks fine, it must be the Network!

 

[l310564]

It is an internal SUSI Drive formated in NTFS.

 

[ptheriault]

Have you tried to restart the services since the disk was added?

- Paul
- Database performance looks fine, it must be the Network!

 

[l310564]

Yes the server has been rebooted several times. Does sql need any other permisions to access the drive?

 

[l310564]

I have been doing so poking around and seems that the D drive is dynamic where as the C drive is standard. Could this have something to do with it?

 

[ptheriault]

That could have something with it. Does it need to be dynamic?

I found this link to convert it to basic.

http://faq.arstechnica.com/link.php?i=1806

- Paul
- Database performance looks fine, it must be the Network!

 

[ptheriault]

I have been doing some research on this and I have found many instances of people having a hard time getting SQL server to see the dynamic disk. I have not been able to find for certian if SQL Server does not support it butI have found post that suggest it doesn't. I have found that it is not supported on a cluster. Are you working with a cluster?

- Paul
- Database performance looks fine, it must be the Network!

 

[l310564]

Ok before i do this could you please tell me what is the diffrence between a dynamic and standard disk?

 

[Catadmin]

I looked it up and found the definition at the following link:

http://www.pcmag.com/encyclopedia_term/0,2542,t=dynamic+disk&i=42176,00.asp

A Windows 2000 feature that allows a single disk reference to span more than one physical disk volume. It also allows the disk to be resized without rebooting (resized "dynamically"). When formatted as a dynamic disk, the volume does not contain partitions. A regular disk partition is called a "basic" disk.

Does this help?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[l310564]

Cheers,

I'll let you know how i get on.