I am in SQL 2005 Management Studio under account that is an administrator on
the Windows 2003 R2 server.

I can't see my local H: & T: drives when I attempt to do backups or restores.

How can I make them available for use in Management Studio?

elpepe (elpepe (AT) discussions (DOT) microsoft.com) writes:
Are you running SSMS on the same machine as SQL Server is running on?
SQL Server will only see the disks on the machine it runs from.

Furthermore are H and T actually local disks, or are they mapped network
devices? In such case you need to use UNC names, as the mapping is on
session level.

Is this a cluster?

What is the service account for SQL Server? If it's LocalSystem,
NetworkService or some such, change to a regular domain account.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Erland -- thanks for your quick reply

This is a cluster and the problem was that the drives were in different
groups. I brought them into the same group as SQL server and created them as
dependencies for the SQL server.

I can see them now -- again thanks for your assistance.

Joe

"Erland Sommarskog" wrote: