SQL server backup in a 2019 VM to s3 using backup URL

Question

Hi I have set up a Windows Server 2019 VM with SQL server 2016. I want to take the backup of SQL server in AWS S3. It should have monitoring and auditing capability and cost effective and secure. I have looked at below link.https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/sql-server-backup-and-restore-with-s3-compatible-object-storage?view=sql-server-ver16 . It mentions that it uses SQL server uses s3 connector to use backup URL integration. Can this be implemented or installed separately to backup SQL server data to s3 with windows server 2019 VM and SQL server 2019 ?

Answer 1

Hi @Pradeep,

Thanks for your information.

Perhaps you didn't notice that the Backup to URL feature to an S3-compatible object storage is only supported in SQL Server 2022, prior versions are not supported.

The same note appears in this article:

If you want to learn the detail steps with how to back up SQL Server data to s3, hope this article can help you well.

https://aws.amazon.com/cn/blogs/modernizing-with-aws/backup-sql-server-to-amazon-s3/

Please feel free to share your issues here.

Best regards,

Lucy Chen

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

https://docs.microsoft.com/en-us/answers/support/email-notifications