+++ noatcards = True isdraft = False +++

RDS SQL Server

RDS SQL Server Basics

RDS offers SQL Server 2008 R2, 2012, 2014, 2016 and 2017 including: Express, Web, Standard and Enterprise.

RDS SQL Server Tips

Recently added support for backup and restore to/from S3 which may make it an attractive DR option for on-premises installations.

RDS SQL Server Gotchas and Limitations

🔸The user is granted only db_owner privileges for each database on the instance.
🔸Storage cannot be expanded for existing databases. If you need more space, you must restore your database on a new instance with larger storage.
🔸There is a 16TB database size limit for non-Express editions. There is also a minimum storage size, 20GB for Web and Express, 200GB for Standard and Enterprise.
🔸Limited to 30 databases per instance