Backup and Restore process of Amazon RDS DB instance

Backup process of Amazon RDS Database instance

Make a backup using DB Snapshot using AWS management console (This is a manual process for taking one DB Snapshot)

DB Snapshots are user-initiated and enable to back up DB instance in a known state as frequently as you wish, and then restore to that specific state at any time. DB Snapshots can be created with the AWS console and are kept until you explicitly delete them with the AWS consloe API.

To create a DB snapshot

1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.
2. In the navigation pane, click DB Instances.
3. Select Instance. Click Instance Actions, and then click Take DB Snapshot.

The Take DB Snapshot window appears.

1. Type the name of the snapshot in the Snapshot Name text box.
2. Click Yes, Take Snapshot.

Automated Backup

Automated backup is an Amazon RDS feature that automatically creates a backup of database. An automated backup occurs during a daily user-configurable period of time known as the preferred backup window. Backups created during the backup window are retained for a user-configurable number of days (the backup retention period).

The preferred backup window is the user-defined period of time during which your DB instance is backed up. When the backup retention changes to a non-zero value, the first backup occurs immediately. Changing the backup retention period to 0 turns off automatic backups for the DB instance, and deletes all existing automated backups for the instance.

Backup Retention Period: The number of days for which automated backups are retained. Setting this parameter to a positive number enables backups. Setting this parameter to 0 disables automated backups.

Restore process of Amazon RDS Database instance

To restore a DB instance from a DB snapshot

1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.
2. In the navigation pane, click Snapshots.
3. Click on the DB snapshot that you want to restore from.
4. Click Restore Snapshot.

The Restore DB Instance window appears.

1. Type the name of the restored DB instance in the DB Instance Identifier text box.
2. Click the Launch DB Instance button.

To restore a DB instance to a specified time (from automated backup)

1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.
2. In the navigation pane, click DB Instances.
3. Select insatnce. Click Instance Actions, and then click Restore To Point In Time.

The Restore DB Instance window appears.

1. Click on the Use Custom Restore Time radio button.
2. Enter the date and time that you wish to restore to in the Use Custom Restore Time text boxes.
3. Type the name of the restored DB instance in the DB Instance Identifier text box.
4. Click the Launch DB Instance button.