Friday, May 04, 2012 12:20 PMI 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.
Monday, May 07, 2012 6:22 AMModerator
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.
TechNet Community Support
- Marked As Answer by Stephanie LvModerator Monday, May 14, 2012 8:28 AM
Monday, May 14, 2012 8:59 AMwhat 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.