How can I make SQL Server 2012 scale to size over 1TB on Amazon AWS

Question

I want to install SQL Server 2012 Web on Amazon AWS, but I want my Database to be able to scale automatically. With Amazon I am limited to EBS volumes of 1TB of size. What happens when my database grows. How do I use SQL Server 2012 to scale on amazon AWS.

Answer 1

Hi Idan Shechter,

The maximum database size of SQL Server 2012 Web edition can be up to 524PB, so the limitation of 1 TB is on the amazon web services side. From the SQL Server point of view, you may monitor the size of database manually, and split the database into two, or switch out the history data into other database if possible, when the size is close to the limitation. For better assistance in your scenario, I would recommend you consult with support experts on amazon web services.

---

Stephanie Lv

TechNet Community Support

Answer 2

what do you mean by splitting the database into two. Can I start with a single database and have a solution that helps me do that without changing my code.