Skip to content

RDS instance restored from snapshot

0

I can successfully restore a new AWS Postgres RDS instance using the snapshot of another instance. However, I want to understand where can I find the log stating the new rds instance is created using a particular snapshot. Also how do I retain the log or event for more than a year.

asked 2 years ago566 views

1 Answer
0

When you restore an RDS instance from a snapshot, AWS creates a new RDS instance rather than overwriting an existing one. The creation of this new instance is logged as an event in the Amazon RDS console.

To find the log stating that the new RDS instance was created using a particular snapshot:

  1. Open the Amazon RDS console
  2. Navigate to the "Events" section
  3. Look for an event with a message similar to "Restored from snapshot [snapshot-name]" associated with your new RDS instance

By default, these events are retained for a limited time. To retain the log or event for more than a year, you have a few options:

  1. Use AWS CloudTrail: This service provides a more comprehensive record of actions taken in your AWS account, including RDS snapshot restorations. CloudTrail logs can be stored in an S3 bucket for long-term retention.

  2. Configure RDS Event Subscription: You can create an event subscription that sends notifications to an Amazon SNS topic when specific RDS events occur. These notifications can then be stored long-term in a database or other storage solution of your choice.

  3. Use AWS Config: This service can track configuration changes in your AWS resources over time, including RDS instance creations and modifications.

Remember that retaining logs for extended periods may have cost implications, so consider your specific needs and compliance requirements when deciding on a long-term log retention strategy.
Sources
RDS Restore snapshot | AWS re:Post
Restoring from an RDS Custom for SQL Server DB snapshot - Amazon Relational Database Service

answered 2 years ago

EXPERT

reviewed 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.