i don't understand clearly your concept described in first part of your response. Could you give me more information to understand it and could help you? you have two servers with one shared folder on each of them. One server on-site and one out-site network
, right? and you have SQL server which you want copy data to this shares?
Second parts of your response is depend of which type of OS is use, if computers enable firewall or enable network discovery, if on network adapter is enable "File and Printer Sharing for Microsoft Networks", etc.
DFS -->
https://en.wikipedia.org/wiki/Distributed_File_System_(Microsoft)
Hi Jakub,
By using the DFS seem to be more complicated for me.
Actually, What is need is to create a shared folder that could be recognized by both database server in the premise and also on the cloud. I know that creating a shared drive and then mapped to both of the server is very easy, but SQL server is not recognizing
the mapped drive. So, I plan that if I could publish the shared drive on the AD, then it should be easier.
The concept of SQL server replication is in this way. The In premise SQL Server will always copy the log files to the folder inside the shared folder and then the cloud SQL Server will establish connection to the shared drive and copy the log files
from the shared drive and apply it to the cloud database.
The Database Administrator has the difficulty of mapping the mapped shared drive in the sql server as sql server is not recognizing the mapped shared drive. if the shared folder in the active directory, there might be high chances that the sql server able
to detect it.
Thanks.
Regards,