Backup to AWS and Azure

Answers

• Options

  petey2 Redgate › Posts: 87 Silver 3

  March 28, 2022 1:02AM

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

  SQL Backup - beyond compression

  0 · Share on Twitter
• Options

  pellegrini Posts: 2 New member

  March 31, 2022 8:50AM

  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!

  0 · Share on Twitter
• Options

  petey2 Redgate › Posts: 87 Silver 3

  March 31, 2022 9:11AM

  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.

  SQL Backup - beyond compression

  0 · Share on Twitter
• Options

  NeilT123 Posts: 1 New member

  March 30, 2023 6:03PM

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

  0 · Share on Twitter