Can someone help me with a way to FTP backup file and transaction logs files from sql server 2005 to another sql server 2005. This is the only option that can be used for transfering the data for restore on the secondary server due to some issues.
A sql script will be help or a script that uses ssis FTP process.