Presently we have 20 remote locations that either are on a WAN or VPN connection to the central server. We have independent database located at each location and a routine is running to pass information from remotes to central by means of XML documents(all changes made at remotes) being transferred to the central server. In return, this routine is getting XML documents of changes to the Central Database and using to update the remote databases.

Just recently we have included the Voice over the WAN as well and we have been experiencing failures in the transfer of these filed.

Question I have is what is the best practice for transferring these files. Using the "rename" seems to work well, but everyonce in awhile there is a failure where the resulting document being moved to the central location is incomplete. Our WAN is handling both voice and data and from what I understand Voice take presidence over Data. We have been monitoring the bandwidth usage and are speculating the issue is when voice is maximizing the system. The "rename" is inside a Try Catch routine, but I question if I am getting an error when this happens. I have replaced the "rename" with a "copy" from remote to central, but once again we seem to be getting some failures that do not seem to be captured by the Try Catch.(average size of documents are <= 4kb)

This process has kept our databases synchronized very good where we are looking at 30 second to 1 minute delay, but with the failures we are experiencing, we have been doing double transmits thus causing lots more traffic and overhead. The number of transactions has been averaging about 18000 to 24000 per day.

Any suggestions would be greatly appreciated.