I had around 80 databases on one SQL server that backup nightly to an external hard drive with a separate folder for each database. A VBScript would then run that would zip the .bak files and delete any of them older than 7 days.
My situation now is that I am trying to run my backups to a NAS and after that didn't work due to network/latency I would like to backup the databases to a local disk and then move them to the NAS while keeping the folder structure in place on the NAS.
My question is what would be the best tool to do this. Should I use VBScript to move the all folders and overwrite them on the NAS or is there a better way through SQL or PowerShell to move only the new zipped .bak's to the remote folder?
Thanks,
Matt