How to configure the RDS SQL Server long term backups.

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.

Sujets

Balises

Langue

English

demandé il y a 3 mois239 vues

2 réponses

Ces réponses sont-elles utiles ? Votez pour la bonne réponse pour aider la communauté à bénéficier de vos connaissances.

Réponse acceptée

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/

Best,

Didier

EXPERT

répondu il y a 3 mois

EXPERT

vérifié il y a 3 mois

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?

répondu il y a 3 mois

Didier_Durand EXPERT
il y a 3 mois
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!

Contenus pertinents