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?
- Newest
- Most votes
- Most comments
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.
Relevant content
- asked a year ago
- asked 2 months ago
AWS OFFICIALUpdated 10 months ago- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 3 days ago
