February 17, 2011 at 8:31 am
Hi I have been trying to do FTP through SQL Script.
The script does connect the destination server and drop the file in appropriate folder.
It is working fine with small size of file, But I have the file size 20gb It is not working and giving the following error:
Connection closed by remote host.
Netout :Connection reset by peer
My intention is to schedule a job,which transfer the backup file from Production environment to Dev and there I have to write another
job to restore the database when ever the new file came or overwrite occurs on the old file.
Can some one please help me on that. Thanks in advance.
February 17, 2011 at 9:38 am
What size files were going across without any problem? Have you looked into increasing the FTP buffer window?
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
February 17, 2011 at 11:42 am
What size files were going across without any problem? Have you looked into increasing the FTP buffer window?
Hi Chris, Thanks for quick reply.
upto 100 mb - 2gb files were transferring good. And even these kind of files are also giving the same issues sometimes.
And I dont know about FTP buffer window. where do I need to see that? And what is the process to do this?
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply