Amazon Relational Database Service
User Guide (API Version 2012-01-15)
Print this pageEmail this pageGo to the ForumsView the PDFShare this page on TwitterShare this page on FacebookBookmark this page on DeliciousSubmit this page to RedditSubmit this page to DiggDid this page help you?  Yes  No   Tell us about it...

Working With Automated Backups

Amazon RDS can automatically back up all of your DB Instances. You can set the backup retention period when you create a DB Instance. If you don't set the backup retention period, Amazon RDS uses a default period retention period of one day (Amazon RDS does not charge for a backup retention period of one day). You can modify the backup retention period; valie values are 0 (for no backup retention) to a maximum of 8 days.

In this example, you will enable and then disable backups for an existing DB Instance called mydbinstance.

Disabling Automated Backups

You may want to temporarily disable automated backups in certain situations; for example, while loading large amounts of data.

[Important]Important

We highly discourage disabling automated backups because it disables point-in-time recovery. If you disable and then re-enable automated backups, you are only able to restore starting from the time you re-enabled automated backups.

In these examples, you disable automated backups for a DB Instance by setting the backup retention parameter to 0.

AWS Management Console

To disable automated backups immediately

  1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.

  2. In the My DB Instances list, select the check box next to the DB Instance you want to delete.

  3. Click the Modify button.

    The Modify DB Instance window appears.

  4. Select 0 in the Backup Retention Period drop-down list box.

  5. Check the Apply Immediately check box.

  6. Click the OK button.

CLI

To disable automated backups immediately

  1. Set the backup retention period to 0.

    PROMPT>rds-modify-db-instance mydbinstance --backup-retention-period 0 --apply-immediately

  2. Call rds-describe-db-instances for the DB Instance until the value for backup retention period is 0 and mydbinstance status is available.

    PROMPT>rds-describe-db-instances mydbinstance --headers

API

To disable automated backups immediately

  • Call ModifyDBInstance with the following parameters:

    • DBInstanceIdentifier = mydbinstance

    • BackupRetentionPeriod = 0

    Example

    https://rds.amazonaws.com/
     ?Action=ModifyDBInstance
     &DBInstanceIdentifier=mydbinstance
     &BackupRetentionPeriod=0
     &SignatureVersion=2
     &SignatureMethod=HmacSHA256
     &Timestamp=2009-10-14T17%3A48%3A21.746Z
     &AWSAccessKeyId=<AWS Access Key ID>
     &Signature=<Signature>
    							 

Enabling Automated Backups

If your DB Instance doesn't have automated backups enabled, you can enable them at any time. The same request used to disable automated backups can be used to enable them by using a non-zero value for the backup retention period. When automated backups are enabled, a backup is immediately created.

In this example, you enable automated backups for a DB Instance by setting the backup retention period parameter for the DB Instance to a non-zero value (in this case, 3).

AWS Management Console

To enable automated backups immediately

  1. Launch the AWS Management Console.

    1. Go to the AWS Management Console web page.

    2. Select Amazon RDS from the drop-down list under the Sign in to the AWS Console button, and then click the Sign in to the AWS Console button.

  2. In the My DB Instances list, select the check box next to the DB Instance you wish to delete.

  3. Click the Modify button or right-click the DB Instance and select Modify from the context menu.

    The Modify DB Instance window appears.

  4. Select 3 in the Backup Retention Period drop-down list box.

  5. Check the Apply Immediately check box.

  6. Click the OK button.

CLI

To enable automated backups immediately

In this example, we will enable automated backups by setting the backup retention period to 3.

  • Set the backup retention period to 3.

    PROMPT>rds-modify-db-instance mydbinstance --backup-retention-period 3 --apply-immediately

API

To enable automated backups immediately

  • Call ModifyDBInstance with the following parameters:

    • DBInstanceIdentifier = mydbinstance

    • BackupRetentionPeriod = 3

    • ApplyImmediately = true

    Example

    https://rds.amazonaws.com/
     ?Action=ModifyDBInstance
     &DBInstanceIdentifier=mydbinstance
     &BackupRetentionPeriod=3
     &ApplyImmediately=true
     &SignatureVersion=2
     &SignatureMethod=HmacSHA256
     &Timestamp=2009-10-14T17%3A48%3A21.746Z
     &AWSAccessKeyId=<AWS Access Key ID>
     &Signature=<Signature>