SQL server backup in windows 2019 VM to s3

0

Hi all,

Currently the SQL server is hosted in Windows server 2019 VM. I want to export the DB level backups to s3. But it looks like it's only supported in 2022. Anybody knows if there is way we can install specific packages/plugin to support the below in Windows server 2019 VM rather than upgrading to a Windows server 2022?

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

If not what are the other alternatives to migrate the backups to s3 with auditing capability.

Regards Nib

nib
질문됨 한 달 전280회 조회
1개 답변
0

Hi

Note, the Backup to URL feature to an S3-compatible object storage is only supported in SQL Server 2022, prior versions are not supported.

  1. You can consider some alternatives instead of the Backup Url Feature.
  • You can use the Powershell script to create backup and copy the backup to s3
  • or You can use system manager
  1. Another alternative AWS DMS: Auditing: DMS includes some auditing, but it primarily focuses on the migration process itself (data changes, errors). It depends on the depth of auditing you require. If you need detailed auditing of backup access, modification, retention, and finer-grained activity tracking tailored specifically for backups, a dedicated backup tool or the custom auditing solution on S3 might be better.

  2. use third party tools such as Cloudberry or veem many more

4.Upgrading to 2022 or newer could definitely be a viable option for your SQL Server backup scenario. https://aws.amazon.com/blogs/mt/upgrading-sql-server-using-ec2-systems-manager/

profile picture
전문가
GK
답변함 한 달 전
profile picture
전문가
검토됨 한 달 전
  • You could migrate to RDS also and then you can backup to S3 even at 2019

  • gary, Thanks for adding the missing piece, It would be always good option to use RDS managed instead of the managing the Ec2 stuff with SQL

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠