1. Login to AWS Console: Go to the AWS Management Console (https://aws.amazon.com/console/) and log in to your AWS account.
2. Navigate to RDS Service: Click on the ‘Services’ dropdown menu at the top left corner of the console, then select ‘RDS’ under the ‘Database’ section.
3. Select the RDS Instance: In the RDS dashboard, select the RDS instance for which you want to enable Recovery Points by clicking on the checkbox next to the instance name.
4. Enable Automated Backups: Click on the ‘Modify’ button at the top of the dashboard to modify the settings of the selected RDS instance.
5. Configure Backup Settings: Scroll down to the ‘Backup’ section of the Modify DB Instance page. Here, you will find the ‘Backup retention period’ setting. Set the desired number of days for which you want to retain automated backups. This will ensure that recovery points are created and retained for the specified period.
6. Enable Automated Backups: Make sure that the ‘Backup retention period’ is set to a value greater than 0 to enable automated backups for the RDS instance.
7. Save Changes: Scroll down to the bottom of the page and click on the ‘Continue’ button, review the changes, and then click on the ‘Modify DB Instance’ button to save the changes.
8. Verify Configuration: Once the modification is completed, go back to the RDS dashboard and check the ‘Backup’ section of the RDS instance to ensure that automated backups are enabled and the backup retention period is set as per your configuration.

​

1. Install Boto3 library: Ensure you have the Boto3 library installed. You can install it using pip:

pip install boto3

2. Configure AWS credentials: Make sure you have AWS credentials configured on your system. You can set it up by running:

aws configure

3. Write Python script to create a manual snapshot: Create a Python script (e.g., create_rds_snapshot.py) with the following code snippet:

import boto3

# Define the AWS region and RDS instance identifier
region = 'your_aws_region'
instance_identifier = 'your_rds_instance_identifier'

# Create a boto3 client for RDS
rds_client = boto3.client('rds', region_name=region)

# Create a manual snapshot for the RDS instance
response = rds_client.create_db_snapshot(
    DBSnapshotIdentifier='manual-snapshot-' + instance_identifier,
    DBInstanceIdentifier=instance_identifier
)

print("Manual snapshot created successfully: ", response)

4. Run the Python script: Execute the Python script using the following command:

python create_rds_snapshot.py

5. Verify the manual snapshot: Go to the AWS Management Console, navigate to the RDS service, select your RDS instance, and check if the manual snapshot was created successfully.