Sql server 2014: backup log to 2 destinations

We want a single job to back up log to azure and file system every time.

So we can log ship from file system and from azure at the same time.

I seem to recall that the redgate sql backup tool has a "backup and copy to..." feature. In sql natively yet?

Can this be done?

I've never used SSIS to use the backup task so I'm not sure exactly how great this solution is however it should theoretically work and it took me about 10 minutes instead of 10 days.

First off create a package and make your backup database task. Set it up however you need to set it up like this.

Then make a for each file loop and have it search through the directory you're adding it to.

Map the results to a variable.

Then use file System tasks to move it wherever the hell you want.

StackExchange Database Administrators Q#89987, answer score: 2