By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

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.

Topics
StorageMigration & ModernizationDatabase
Tags
Backup & RecoveryGeneral Database MigrationsAWS BackupDatabaseAmazon RDS for SQL Server
Language
English
Sanjeev_Reddy
asked 10 months ago429 views
2 Answers
1
Accepted Answer

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
EXPERT
Didier_Durand
answered 10 months ago
profile picture
EXPERT
Oleksii Bebych
reviewed 5 months ago
profile picture
EXPERT
Riku_Kobayashi
reviewed 10 months ago
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?

Sanjeev_Reddy
answered 10 months ago
  • Didier_Durand EXPERT
    10 months ago

    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!

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content