We are working with a Windows Server 2003/SQL 2000
cluster. We have split our SAN volumes into three
separate drives. From Enterprise Manager, we are only
able to view one drive, which is the SAN drive the SQL
system data was installed. We tried going through
creating a new database, backing up and restoring, but
only saw the one drive.

From Query Analyzer, we are able to perform directory
listing on the other drives.

Any ideas?

You must add the new SQL data drives to the SQL resource group as physical
disk resources.. You must then make SQL dependant on all the new data
drives.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"Theo Jones" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Thanks for the information.

I already had all of the physical disks defined as
resources, but I did not have all of them listed as
dependencies.

Thanks again!