Post reply

FTP B/u

  • January 5, 2004 at 11:46 am

    #107569

    Does anyone know of a way to make a back up of a database and have it FTP to another server? 

    Can this be done with a DTS package?

    Thanks,

    -Carlos

  • January 5, 2004 at 6:50 pm

    #488751

    You can use xp_cmdshell to call the command-line ftp client. If you've got all the commands to execute in order (including the login), you can use the -s:<filename> to tell the client to execute the script. The FTP task in DTS can retrieve but it does not push files. You'd have to do something similar to what I just described (or use an ActiveX control... there are some out there that do FTP) in order to push a backup to a different server within DTS.

     

    K. Brian Kelley
    @kbriankelley

  • January 6, 2004 at 11:04 am

    #488846

    http://www.sqlservercentral.com/columnists/sjones/pushftp.asp

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply