There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
Missing table(s) in exported data
I've noticed that while exporting big databases (> 100 GB) from Azure it happens sometimes that there are bulk copy data missing in the output folder for some tables. It doesn't happen all the time and it doesn't happen with the same table all the time.
I started to investigate it closer and I see that around place where where there should be logging messages about exporting data from the missing table there is just the following message:
"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
There are no additional error details around but I assume that the bcp export tool ends up with timeout. Is it possible to implement retry policy in case of timeout or at least add some summary section that there were some error(s) detected and what were those
errors. The current result log is too verbose and it is very easy to miss this type of error (actually we discovered it just by invalid reports from the copied databases).