I've got two servers on a workgroup and I need to transfer my SQL Server 2008 Backups from the local drive of one to a network drive on another. Ideally, I'd like to have SQL call the Powershell script after it does the backup. Anyone have a script that does this? Is there a better way?
I tried to have SQL Backup straight to the network drive but it doesn't seem I can do that without them being on the same domain.