在AWS上增加现有SQL Server RDS实例的存储 [英] Increasing the storage of an existing SQL Server RDS instance on AWS

问题描述

是否可以增加AWS上现有SQL Server RDS实例的存储容量?

Is there a way to increase the storage capacity of an existing SQL Server RDS instance on AWS ?

AWS文档说它不能按照 https://aws.amazon.com/premiumsupport/knowledge-center/rds-out-of-storage/

AWS documentation says it can't be as per https://aws.amazon.com/premiumsupport/knowledge-center/rds-out-of-storage/

还有哪些其他方法可以实现这一目标?人们如何像在生产场景中那样实时处理这种情况?

What are other alternatives to achieve this ? How are people dealing with this situation in real time like in the case of production scenario ?

推荐答案

不可能在Amazon RDS上增加SQL Server数据库的存储.

Its not possible to increase the storage for SQL Server Database on Amazon RDS.

http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ModifyInstance.SQLServer.html

http://docs.aws.amazon.com/AmazonRDS/Latest/UserGuide/CHAP_SQLServer.html

https://aws.amazon.com/premiumsupport/knowledge-center/rds-out-of-storage/

唯一的选择是创建一个具有更大大小的新RDS实例并迁移所有数据库/数据库

The only option is to Create a new RDS instance with more size and migrate all the data/databases

http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html

这的确吸收和挑战了云的含义，我真的不知道整个世界如何处理这种情况，尤其是在数据快速增长的生产环境中.另外，用于数据迁移的Amazon DMS服务根本没有用，因为它不传输身份列，外键/辅助键/索引和存储过程/函数/触发器.

This really really sucks and defy the meaning of cloud, i really dont have any idea how the whole world is handlin this scenario especially in production environments where data grows rapidly. Also the Amazon DMS service for Data Migartion is not useful at all as it does not transfer the Identity columns, foreign keys/secondary keys/Indexes and Stored Procedures/Functions/Triggers.

这篇关于在AWS上增加现有SQL Server RDS实例的存储的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！