In the Amazon RDS which uses the SQL Server engine, what is the maximum size for a Microsoft SQL Server
DB Instance with SQL Server Express edition?
A.
10 GB per DB
B.
100 GB per DB
C.
2 TB per DB
D.
1TB per DB
Explanation:
The maximum storage size for a Microsoft SQL Server DB Instance is 4 TB for all instances except the SQL
Server Express edition, which limits storage to a total of 300 GB. The minimum storage size for a Microsoft
SQL Server DB Instance is 20 GB for the Microsoft SQL Server Express and Web Editions and 200 GB for the
Standard and Enterprise Editions.
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html
Where is it mentioned as 10 GB in the documentation??
You can create up to 30 databases on each of your DB instances running Microsoft SQL Server.
C是正确的
D
Minimum: 20 GB, Maximum: 1024 GB
D
The maximum storage size for SQL Server DB instances is the following:
General Purpose (SSD) storage: 4 TB for all editions
Provisioned IOPS storage: 4 TB for all editions
Magnetic storage: 1 TB for all editions
Its not a AWS Limit, its a SQL Server Express DB Size Limit of 10GB for the Express Edition
使用 Express Edition 版时，此最大存储空间为 300 GB？？！！
http://docs.aws.amazon.com/zh_cn/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html
A is correct.
https://www.microsoft.com/en-us/sql-server/sql-server-2016-editions
“Build small, data-driven web and mobile applications up to 10 GB in size with this entry-level database. Available for free.”
this is an obsoleted question and the limit from the provided doc
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html
are
The maximum storage size for SQL Server DB instances is the following:
General Purpose (SSD) storage: 16 TB for all editions
Provisioned IOPS storage: 16 TB for all editions
Magnetic storage: 1 TB for all editions
Weird! Either it has increased in the mean time from 10 to 16GB or they have forgoten to mention “magnetic storage” in the question?
A: (Verified)
From the AWS console navigate to RDS>Instances>Launch DB instance > Select Microsoft SQL Server Edition –
Affordable database management system that supports database sizes up to 10 GB.