More Info:
As an organization you should have a backup policy with atleast minimum 7 days.Risk Level
MediumAddress
Operational Maturity, Reliability, SecurityCompliance Standards
GDPRTriage and Remediation
Remediation
Using Console
Using Console
To remediate the backup retention duration misconfiguration for an AWS RDS instance using the AWS Management Console, follow these steps:
-
Sign in to the AWS Management Console:
- Go to https://aws.amazon.com/ and sign in to the AWS Management Console using your credentials.
-
Navigate to the RDS Console:
- In the AWS Management Console, navigate to the Amazon RDS console by clicking on “Services” at the top of the page and then selecting “RDS” under the Database section.
-
Select the RDS Instance:
- From the list of RDS instances, select the instance for which you want to set the backup retention duration.
-
Modify the Backup Retention Period:
- Click on the instance name to open its details page.
- In the navigation pane on the left, click on “Modify”.
- Scroll down to the “Backup” section.
- Locate the “Backup retention period” option and set the desired backup retention duration in days. The valid values range from 0 (for disabling automated backups) to a maximum of 35 days.
-
Apply the Changes:
- Scroll to the bottom of the page and click on the “Continue” button.
- Review the summary of changes and click on the “Modify DB Instance” button to apply the new backup retention duration.
-
Monitor the Modification:
- Once the modification is complete, you can monitor the progress in the RDS console. The instance may undergo a brief downtime during the modification process.
Using CLI
Using CLI
To remediate the issue of missing Backup Retention Duration for an AWS RDS instance using AWS CLI, you can follow these steps:
-
List Current Backup Retention Settings:
Run the following AWS CLI command to list the current backup retention settings for your RDS instance:
-
Update Backup Retention Duration:
Run the following AWS CLI command to modify the backup retention period for your RDS instance. Replace
YOUR_DB_INSTANCE_IDENTIFIER
with the actual identifier of your RDS instance andNEW_RETENTION_PERIOD
with the desired retention period in days: -
Verify the Changes:
Run the
describe-db-instances
command again to verify that the backup retention period has been updated successfully: - Monitor the Backup Retention: Monitor the backup retention settings periodically to ensure that the changes are applied correctly and the backups are retained for the specified duration.
Using Python
Using Python
To remediate the backup retention duration misconfiguration for AWS RDS using Python, you can use the AWS SDK for Python (Boto3). Here are the step-by-step instructions:
-
Install Boto3:
If you haven’t already installed Boto3, you can install it using pip:
- Write a Python script to update the backup retention duration for the desired RDS instance. Here’s an example script:
-
Replace
'your_rds_instance_identifier'
with the actual identifier of your RDS instance. -
Set the
backup_retention_period
variable to the desired retention period in days. - Run the Python script. This script will update the backup retention period for the specified RDS instance to the value you set.