How to export AWS RDS snapshot to your own S3 bucket?

Question

I am using a SQL Server Express AWS RDS instance. The RDS is backing up daily.

I've found that the RDS snapshot is actually stored in S3. But is it possible to export data to your own S3 bucket?

Answer 1

Snapshots are stored in S3 but AWS do not make them visible. Similar question/answer in AWS forums: https://forums.aws.amazon.com/message.jspa?messageID=560995. You will need to do a database dump. https://msdn.microsoft.com/en-us/library/ms187510.aspx looks like a good guide on how to do this.

Update 3rd Feb: AWS now allows you to access the s3 snapshot, you can either download and use it elsewhere or use directly using athena or redshift

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_ExportSnapshot.html