I'd like to automate the process of copying some data off-site. I am currently manually using ftp to copy the newest sql .bak and .trn files from the SQL backup folder on disk. First, I rar the latest backup and all trn files into one .rar file. I then transfer this rar file to a remote ftp server and delete the previous one.
It would be great to come up with a batch or script that can handle this for me. The part I am having trouble with is writing a script that finds the newest .bak file and any .trn files that are newer than that in a specific directory. I then want to take all of those filenames and build a rar package. I am not sure is a batch file or wsh is the best approach, or necessarily how to do what I need to do in either of those environments.
Windows 2000 server.