zip and copy a file from one folder on one server, and paste it into a different folder on a different server.
the issue is that the files are large so it must be compressed first, and then moved to a completely different server.
the sql backups are run from the sql server job queue, and are scheduled so the script would need to watch for when the file hits the folder, zip it and move it to the new server.
This will become a scheduled nightly task on the two servers.
I don't even know where to begin..... so i decided to ask for help.
any help will be greatly appreciated!!!