Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

FTP the back up from one server to antoher server Expand / Collapse
Author
Message
Posted Thursday, February 17, 2011 8:31 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, April 03, 2014 1:26 PM
Points: 437, Visits: 255
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.
Post #1065715
Posted Thursday, February 17, 2011 9:38 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 6:38 AM
Points: 1,620, Visits: 1,310
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.
Post #1065788
Posted Thursday, February 17, 2011 11:42 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, April 03, 2014 1:26 PM
Points: 437, Visits: 255
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
Post #1065887
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse