Hi,
I use a TSOT to copy approx 700 tables between one server and another as an overnight package. This data is set to replace and there are no other objects (views, etc) being copied. What I have noticed by looking at the event log, is that it takes about 1 and 1/2 hours between the package being started and the data to start copying over. In the progress tab it tells me that all the Tables alread exist in the destination (as expected), that there are no other objects to copy. Then it just sits there till the event log starts to record the table copies. I have tried changing it to a replace (thus removing the drop and recreate) and doing a Truncation on all the tables beforehand, but this has not made any differece. Any ideas on what causes this delay and how to remove it would be appreciated.
I use a TSOT to copy approx 700 tables between one server and another as an overnight package. This data is set to replace and there are no other objects (views, etc) being copied. What I have noticed by looking at the event log, is that it takes about 1 and 1/2 hours between the package being started and the data to start copying over. In the progress tab it tells me that all the Tables alread exist in the destination (as expected), that there are no other objects to copy. Then it just sits there till the event log starts to record the table copies. I have tried changing it to a replace (thus removing the drop and recreate) and doing a Truncation on all the tables beforehand, but this has not made any differece. Any ideas on what causes this delay and how to remove it would be appreciated.