snapshot ftp error: (12031) The Connection with the server was reset

[smsinger3]

Hello all. I have a 285mb snapshot that I am trying to FTP to another SQL
Server. After I get the message "Bulk copied data into table xyz", I get the
following error messages:

Category:OS
Source:
Number: 12031
Message: The connection with the server was reset


Then, I get the error

The process could not retrieve file '.....table.idx' from the FTP
site 'x.x.x.x'. The step failed.

I realize that the ftp connection must have been broken, but I don't know why.
It's especially strange that it happens AFTER the .bcp file is ftp'd and then
bulk copied.

This works for a 29mb snapshot, but not the 285mb snapshot. Any ideas how to
fix this problem?

Thanks in advance for your help.

Steve S
sms@hmbnet.com

 

[Cagliostro]

I think, the connetion was timeout. Simply try to send smaller portions of data, and tell the result in the forum. John Fill

ivfmd@mail.md

 

[smsinger3]

Thanks JohnFill, I don't think doing it in smaller portions will work because all the data is actually ftp'd and then successfully bulk copied. As soon as it is done bulk copying, I get the message

Category:OS
Source:
Number: 12031
Message: The connection with the server was reset

And then the .idx file is not ftp'd and applied to the table. If I look at the table right now, on the subscriber, all the data is there, but there is no index.

This is very strange. Anyone have any ideas?