RDS for database size more than 16TB

Question

As per AWS documentation the max size supported by AWS RDS DB is 16TB.
My on-prem MS SQL DB is approx 25TB. So I cant use RDS. 
-what are different options available as I migrate this DB to AWS?
- If I install MS SQL on EC2 instance, are there any Pro's and Con's
- Is there any AWS recommended document for installing MS SQL on a EC2 RHEL instance?
- For MS SQL in EC2, how to best design the backup and restore process?

Elvis_P · Answer

There is a lot of ways to look at the ask, best recommendation is to look at the main [SQL page on AWS](https://aws.amazon.com/sql/).

The page has information on Migration methods for SQL and host types you should consider among other things. Additional information on SQL on RHEL as well. Blog on [Deploying SQL on Linux on AWS](https://aws.amazon.com/blogs/opensource/deploying-a-highly-available-microsoft-sql-server-on-linux-on-aws/) will be another resource to us.

For backups, you can use AWS Backup in a lot of cases to backup EC2 instances. Depends on how you want to backup and how often. You can also export the backups to a AWS storage offering like EFS, FSx, or even S3 depending on the architecture.

[RDS running Microsoft SQL](https://aws.amazon.com/rds/sqlserver/) is another option to consider.

RDS for database size more than 16TB

Relevant content