RDS SQL Server backup options


A customer is exploring RDS SQL server. The RDS SQL Server documentation (https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html) states that “Native backups of RDS databases larger than 1 TB aren't supported.” The question came up asking what backup options are available if a database is larger than 1 TB? We know that restores support up to 16 TB (or presumably 64 TB if we get AWS support to stripe volumes), but curious what is driving the backup limitation?

1 Answer
Accepted Answer

1Tb number is not being enforced and not limit actually. It has been empirically determined that backup might take longer than 24 hours on a very small instance. The real limit is 24 hours. If you backup runs around the clock then it will interfere with next day automated backup and will be killed. That's a real limit. 1Tb is derivative of that. So, if you right sized you instance and your backups complete in reasonable amount of time then you can completely ignore 1Tb number.

answered 4 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