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 Friday, January 28, 2011 9:51 AM


SSC-Addicted

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

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 9:42 AM
Points: 442, Visits: 256
Hi I am requesting some one explain the FTP process, I want to ftp the backup from one server to another. I found the solution and was trying to apply, Some times it is working some times it is giving me an error saying Connection close by remote host.I have been getting the same message very frequently. I dont know the reason as i dont have much knowledge on networking and harware. I would really appreciate the response. Thanks
Post #1055421
Posted Wednesday, May 4, 2011 12:08 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 7:44 PM
Points: 4,232, Visits: 4,284
Please refer to the following article.

If it does not work then please provide some additional information so that we can comp up with a solution.


For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1103393
Posted Thursday, May 5, 2011 11:33 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, July 7, 2014 1:39 PM
Points: 1,275, Visits: 220
FTP in a nutshell . . .
FTP client communicates to FTP host via TCP/IP to transfer files.

Transfer errors are "typically " caused by TCP/IP communications errors (but not always.)

Session errors are trickier to diagnose.
i.e. FTP server settings "could" reset the session after a specified time.

Best bet is to enable logging on the server (enabled from the properties of the ftp server site)
and recreate the error / conditions causing the error. (then review the logs.)

Offhand . . . Why FTP?
It's not a bad solution, but the overhead of running a FTP server seems wasteful.
Maybe consider Robocopy as a solution?
http://ss64.com/nt/robocopy.html

e.g. Map a drive (assuming windows environment) and use robocopy to transfer the backup file(s).
(Far easier to setup & diagnose than a full FTP client/server solution.)

M


Free Expert Advice . . .
http://xkcd.com/627/

Mark
Post #1104092
Posted Thursday, May 5, 2011 2:31 PM
SSC-Addicted

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

Group: General Forum Members
Last Login: Monday, April 30, 2012 12:36 PM
Points: 404, Visits: 442
Or backup to the mapped drive if you do not need the original copy.
Post #1104212
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse