I need to access the remote file structure for use in SQL backups.
For example, the remote server named "remote" has the path "C:\backup folder", which is enabled as a remote drive.
I can map to that remote drive as "Z:\backup folder" on my machine.
I can use the various answers in How do I determine a mapped drive's actual path? to determine the UNC path is "\\remote\backup folder". This doesn't work for the SQL backup system, since it is all handled on the remote server.
How can I access the original path on the remote server, "C:\backup folder"?