Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


FTP the back up from one server to antoher server


FTP the back up from one server to antoher server

Author
Message
bvsc
bvsc
Right there with Babe
Right there with Babe (722 reputation)Right there with Babe (722 reputation)Right there with Babe (722 reputation)Right there with Babe (722 reputation)Right there with Babe (722 reputation)Right there with Babe (722 reputation)Right there with Babe (722 reputation)Right there with Babe (722 reputation)

Group: General Forum Members
Points: 722 Visits: 331
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
Welsh Corgi
Welsh Corgi
SSCertifiable
SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)

Group: General Forum Members
Points: 5201 Visits: 4874
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/
mark.pleasance
mark.pleasance
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1596 Visits: 258
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
croberts 36762
croberts 36762
SSC-Addicted
SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)

Group: General Forum Members
Points: 404 Visits: 442
Or backup to the mapped drive if you do not need the original copy.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search