How to take AWS RDS Database Snapshots

PublishedOctober 29, 2024

•3 min read•View as Markdown

George Palangattil

Comments

Join the discussion

No comments yet. Be the first to comment.

More from this blog

Data Encryption with Amazon S3

Introduction Data encryption is a critical component of cloud security, especially when dealing with sensitive workloads in regulated environments. Amazon S3 provides multiple encryption mechanisms that cater to different compliance and operational n...

Jan 10, 20265 min read32

Global Data Durability: Implementing Amazon S3 Cross-Region Replication

Introduction Amazon S3 is a highly durable, scalable object storage service that provides 99.999999999% durability by storing data across multiple Availability Zones. However, certain compliance, latency, and disaster recovery requirements demand sto...

Jan 9, 20263 min read19

Global Data Durability: Implementing Amazon S3 Cross-Region Replication

Advanced Monitoring of AWS Backup Jobs with Notifications

Introduction In modern cloud architectures, backups are not just a compliance checkbox, they are a critical component of resilience and disaster recovery strategies. AWS Backup provides a centralised service to automate backups across AWS services su...

Jan 7, 20264 min read7

Using AWS Systems Manager in Hybrid Cloud Environments

Introduction Hybrid and multicloud strategies are now the norm for enterprises seeking agility, resilience, and compliance. Yet, managing infrastructure that spans AWS, on-premises data centres, and even other public clouds introduces operational com...

Dec 31, 20256 min read43

Using AWS Systems Manager in Hybrid Cloud Environments

Automating AWS Governance with Account Factory for Terraform (AFT)

As organizations scale their cloud footprint, managing AWS accounts with consistent governance, security, and customization becomes increasingly complex. AWS Control Tower Account Factory for Terraform (AFT) bridges this gap by combining the governan...

Sep 15, 20254 min read4

Automating AWS Governance with Account Factory for Terraform (AFT)

George Palangattil's blog

14 posts

Overview

Amazon RDS creates a storage volume snapshot of your DB instance, backing up the entire instance rather than individual databases. When creating this DB snapshot on a Single-AZ DB instance, there is a brief I/O suspension that can last from a few seconds to a few minutes, depending on the size and class of your DB instance. The time required to create a snapshot varies with the size of your databases. Since the snapshot includes the entire storage volume, the size of files, such as temporary files, also affects the duration of the snapshot creation process.

Snapshots of Amazon RDS volumes are incremental, even though database snapshots function operationally as full backups. There are two types of Amazon RDS snapshots: automated and manual. Automated backups occur daily during the preferred backup window, whereas a manual snapshot can be triggered at any time it is needed. Unlike automated backups, manual snapshots are not subject to the backup retention period and do not expire

Step 1 - Select the database

Sign in to the Amazon RDS Console

Go to the AWS Management Console and log in with your credentials. Then In the console, locate and select RDS from the list of services. In the upper-right corner of the RDS console, select the AWS Region where DB instance located.

Select the database

In the left navigation pane of the RDS dashboard, click on Databases. This will display a list of all your RDS instances. Locate and select the database instance from the list.

Prepare Snapshot

Manual Snapshot

Take Snapshot

Select Database then go to actions and click Take Snapshot option

If it is taking the first snapshot, it may take a couple of minutes depending on the size of the database.

Name it and initiate the snapshot

For the snapshot name, use the meaning full and easy to recognise the purpose of each snapshot.

Provide the snapshot name and click on Take Snapshot

Validate the snapshot

Console automatically move to the RDS Snapshots console. Watch on the snapshot name and the status to see the completion

Snapshot is ready, when the status change to Available.

click on the snapshot and validate the details

You successfully created a RDS manual snapshot.

Automated Snapshot

Modify the database configuration

Select the Database and click Modify

Configure the preferred backup window

Scroll down up to the Additional Configuration and set the time under the Backup section

In the next window, select the option when to apply then click on Modify DB instance

You successfully set the automated snapshot(Backup) window

Validate the Automated Snapshot settings

Select the Automated backups section in the left panel (After the scheduled time which set earlier) and find the snapshot form the list.

click on the snapshot and cross check the summary

We have successfully configured and created RDS automated and manual snapshots and validated.

Please remember to delete the resources you created if you did it for learning purposes to avoid unnecessary costs on your account.

Command Palette

Comments

More from this blog

Overview

Step 1 - Select the database

Prepare Snapshot