RDS restore native backup and lazy loading from S3

0

On RDS for SQL Server, I understand that restores from EBS snapshots use lazy loading when downloading data from S3. If I restore a native backup file (.bak) from S3, will this use the same lazy loading as with snapshots or is all the data available on the instance once the restore is completed? Is lazy loading a feature of snapshot restores only?

2 Answers
1

Hello,

If you access data that hasn't been loaded yet, the DB instance immediately downloads the requested data from Amazon S3, and then continues loading the rest of the data in the background.

On tables to which you require quick access, you can perform operations that involve full-table scans, such as SELECT * . This will allow Amazon RDS to download all of the backed-up table data from S3.

Further more, all data is lazy loaded to the DB instance when you restore from a snapshot, the key difference is when you need quick access to the data that hasn't been loaded to the DB instance yet. In this situation, the DB instance will pull the data needed from S3 and make it available instantly without lazy loading.

Additional information about Restoring a DB Snapshot can be found in this AWS Documentation. I'd also advise you to check the Limitations and recommendations for importing backup files from Amazon S3 to Amazon RDS.

And one of them states that,

Importing from Amazon S3 is not supported on the db.t2.micro DB instance class. However, you can restore to a different DB instance class, and change the DB instance class later.

I hope this helps.

Lunga T
answered 2 years ago
0

Dear Customer,

Thanks for reaching out to AWS re:Post.

Adding on to the previous answer, I would also like to add that restores of .bak files from s3 for RDS SQL Server do not cause lazy loading as a snapshot restore in RDS.

Hope this helps with your project - Thank You!

AWS
EXPERT
answered 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.

Guidelines for Answering Questions