Hi Experts -
I'm try to find how data is routed from DB server when exporting to local vs share path. Below is my scenario.
I execute BCP command from ServerA and the database instance is running in ServerB.
I have shared folder in ServerC.
DECLARE @File_Path VARCHAR(MAX) = '\\ServerC\Folder Name\'.
Everything works fine and I see data exported to shared folder \\ServerC\Folder Name\ or my local C:\Temp
In the scenario of shared folder will SQL Server export data directly to \\ServerC\Folder Name\ (ie. ServerB to ServerC)
or will the data be cached in ServerA and then exported to \\ServerC\Folder Name\ ( ie. ServerB -> ServerA(cached) -> ServerC ) since I'm execute BCP command from ServerA?
Thanks
Gopi