Backup to AWS and Azure

pellegrini

Good morning,
is it possible to perform a backup both to AWS and Azure from the same server instance?
In our configuration, if SQL Backup is linked to Azure, it looks like it is not possible to also link to an S3 bucket.

Thanks for your support.

petey2

Hi, no, it's not possible to upload to 2 different cloud storage providers using SQL Backup at this time.

pellegrini

Thanks for your reply. Any known workaround for this? Maybe running two SQL Backup instances on the same server? Thanks for any insight on this!

petey2

It isn't possible to set up two SQL Backup Agent services to serve a single SQL Server instance.  There would be a conflict with the inter-process communication objects used for the SQL Backup extended stored procedure and the SQL Backup Agent.

You would probably need to use third-party tools that can detect when a new backup file has been created, and upload the files to the appropriate cloud storage provider.

NeilT123

I use SQLBackupAndFTP to back up my database and you can select multiple destinations to back up to.