How to configure the RDS SQL Server long term backups.

0

Hello,

As we know AWS RDS SQL Server automated backups configured only 35 days. How to configure RDS SQL Server backups with 90days with point in time.

Can we use the AWS backup feature to retain the backups up to 90days.

2개 답변
0
수락된 답변

Hi,

The best way to implement your backup strategy is to use AWS Backup which is backup as a service: https://aws.amazon.com/backup/

I would suggest you to follow this how-to guide in details: https://aws.amazon.com/getting-started/hands-on/amazon-rds-backup-restore-using-aws-backup/

Best,

Didier

profile pictureAWS
전문가
답변함 3달 전
profile picture
전문가
검토됨 3달 전
0

Thanks Didier, if we suppose we enabled the AWS RDS auto backups and configured the AWS backup, will it create any issues like LSN break.

is it good practice to enable only AWS backups with out AWS RDS auto backups?

답변함 3달 전
  • Hi, when configured properly to keep all needed archives (full + incremental), AWS Backup should not create any issue like LSN breaks. My advice is to test your setup by restoring proactively on separate additional RDS instances. Thanks for accepting my answer!

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

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

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