FTP the back up from one server to antoher server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Notification Services » Administration » FTP the back up from one server to antoher...

FTP the back up from one server to antoher server

Rate Topic

Display Mode

Topic Options

Author

Message

bvsc

Posted Friday, January 28, 2011 9:51 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, January 24, 2013 10:58 AM
Points: 289, Visits: 223

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

Welsh Corgi

Posted Wednesday, May 04, 2011 12:08 PM

Hall of Fame

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 6:19 AM
Points: 3,833, Visits: 4,052

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

mark.pleasance

Posted Thursday, May 05, 2011 11:33 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, June 14, 2013 12:48 PM
Points: 1,270, Visits: 211

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

croberts 36762

Posted Thursday, May 05, 2011 2:31 PM

SSC-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 »

Permissions