I'm trying to work out a way of listing the drives that a particular instance of SQL Server is "aware" of, and understand the process.
I can run
EXEC master..xp_fixeddrives which gives me a list of drives, but when I look in the GUI (Eg. Databases | Restore Database | From device | Add ) the list of available drives is far fewer.
By what process does SQL server become "aware" of a drive and is there any way to problematically determine the drives it is aware of?
Thanks in advance!