Home > IT Answers > SQL Server > SQL 2005 will not recognize other local disks
Rick2766
225 pts.
 SQL 2005 will not recognize other local disks
SQL Server 2005, Storage
SQL Server Management Studio only recognizes one drive on the server, how do I get it to recognize the other Local disks?  The one disk it does see is also on the AX-100, but it will not list any of the others, even the interanl disk, as options for devices to create databases on or for backup desinations, etc.

Thank you,

Rick



Software/Hardware used:
SQL Server 2005, EMC AX-100
ASKED: October 29, 2009  5:26 PM
UPDATED: October 30, 2009  12:46 PM
RELATED QUESTIONS
Answer Wiki:
Is your SQL Server Instance Clustered?
Last Wiki Answer Submitted:  October 29, 2009  9:49 pm  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Ah, yes – It is actually.. I am not used to a clustered server environment. I opened up Cluster Administrator, and under the active server drop down, and Active Resources folder I modified Disk D: so that it is now in the same group as disk S:, but I still can not see disk D as an option in SQL. The 2nd server has actually been down for a week for various different reasons.. so I can’t make the same change there yet.

Rick2766
 225 pts.
 

I believe I have it figured out. Later this weekend i’ll take the SQL Server group off-line, and add the additional disk drives I would like to see to the dependencies list for the SQL Server Service, and bring it back-online. Thank you for the tip on where to look.

Rick2766
 225 pts.