Repetitive tasks through SQL Server

  • Pardon me, I'm new at this.  I work at a remote site and I'm expected to copy backups of 5 databases (sized 90 to 400 MB) to my local box every day.  I can't access the server they're on, only the ftp site from which i can copy them.  Is there a way to automate this process?

  • You can use SSIS package to backup and copy the files to ftp location and schedule the package to run as needed...

    In SSIS package you have to EXECUTE SQL TASK and FTP task ...

     

    MohammedU
    Microsoft SQL Server MVP

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

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