January 28, 2011 at 9:51 am
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
May 4, 2011 at 12:08 pm
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/
May 5, 2011 at 11:33 am
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
May 5, 2011 at 2:31 pm
Or backup to the mapped drive if you do not need the original copy.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply