Hi I have been trying to do FTP through SQL Script.
The script does connect the destination server and drop the file in appropriate folder.
It is working fine with small size of file, But I have the file size 20gb It is not working and giving the following error:
Connection closed by remote host.
Netout :Connection reset by peer
My intention is to schedule a job,which transfer the backup file from Production environment to Dev and there I have to write another
job to restore the database when ever the new file came or overwrite occurs on the old file.
Can some one please help me on that. Thanks in advance.