Post reply

T-SQL Script to Transfer Logfiles to different server

  • March 2, 2008 at 12:54 pm

    #183388

    Any help from all the SQL Guru's will be appreaciated.

    I am looking for a T-SQL script that I can use to transfer transaction logfiles constant from one server's folder to another remote server's folder. I can add this script or logic inside a sql task in ssis or inside an execute process task in ssis. Transaction log occurs every 15 mins on the source server and will need to be transfered to the destination server. The only option for this is throught FTP but I need the code for the process.

    Also I will need a script to delete files from the remote server older than 7 days.

    Thanks as always.

  • March 2, 2008 at 7:51 pm

    #784279

    T-SQL cannot do this . You will need some sort of scripting to handle the transfer. You might be able to kick off the transfer with xp_cmdshell, but you are really looking for a file scripting solution.

    Also, don't cross post. Handled here: http://www.sqlservercentral.com/Forums/Topic462945-148-1.aspx

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

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