what is the maximum size for a Microsoft SQL Server DB Instance with SQL Server Express edition?

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?

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



Leave a Reply 24

Your email address will not be published. Required fields are marked *


Chef

Chef

the question is deprecated.

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

I’d go with A for the “test correct answer.”

muthu

muthu

For this question A may looks better.

SQL Server Express Edition 2005, 2008, 2008 R2, 2012, 2014, and 2016: An entry-level database product that enables small database applications. The maximum size of a database supported is 10 GB. This product is offered at no-additional cost over the base Microsoft Windows Server instance price on EC2.

https://aws.amazon.com/windows/products/sql/

Srinivasu Muchcherla

Srinivasu Muchcherla

SQL Server Express
Microsoft SQLServer Express Edition
Microsoft SQL Server Express Edition is an affordable database management system that supports database sizes up to 10 GB. Refer to Microsoft’s web site for more details.

RC

RC

The question is deprecated. The question was valid before 2014.

co

co

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.

co

co

Correction for max:
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.

networkmanagers

networkmanagers

I agree with the answer. A

BM

BM

The maximum number of databases on a single Microsoft SQL Server DB instance is 30.
The maximum storage size for a SQL Server DB instance is 4 TB for the Enterprise, Standard, and Web editions, and 300 GB for the Express edition.
300GB/30 = 10G per DB

Halloween

Halloween

Yup, this is correct. Do it for yourself in the console.
Select Express Edition.
As soon as you try and allocate more than 300GB of storage, you receive a warning message in red. It says in the message, “Please note that SQL Express limits storage to 10GB per database”.

Answer A is “10GB per DB”.
A is correct.

Amitava

Amitava

No answer is correct. It should be 300GB.

Leo Kennedy A, Senior Consultant, Veeras Infotek, India

Leo Kennedy A, Senior Consultant, Veeras Infotek, India

The maximum storage size for a SQL Server DB instance is 4 TB for the Enterprise, Standard, and Web editions, and 300 GB for the Express edition.

Looks like answers are wrongly listed.

Learning DBA

Learning DBA

Answer is D

I tested it on AWS console for express edition.

(Minimum: 20 GB, Maximum: 1024 GB) Higher allocated storage may improve IOPS performance.

kim

kim

Limits for Microsoft SQL Server DB Instances

The Amazon RDS implementation of Microsoft SQL Server on a DB instance have some limitations you should be aware of:

You can create up to 30 databases on each of your DB instances running Microsoft SQL Server. The Microsoft system databases, such as master and model, don’t count toward this limit.
Some ports are reserved for Amazon RDS use and you can’t use them when you create a DB instance.
Amazon RDS for SQL Server does not support importing data into the msdb database.
You can’t rename databases on a DB instance in a SQL Server Multi-AZ with Mirroring deployment.
The minimum storage size for a SQL Server DB instance is 20 GB for the Express and Web Editions, and 200 GB for the Standard and Enterprise Editions.
The maximum storage size for a SQL Server DB instance is 4 TB for the Enterprise, Standard, and Web editions, and 300 GB for the Express edition.
If you have a scenario that requires a larger amount of storage, it is possible to use sharding across multiple DB instances to get around this limit. This approach requires data-dependent routing logic in applications that connect to the sharded system, so that data gets queried from and written to the appropriate shard. You can either use an existing framework like Hibernate Shards or write custom code to enable this. If you do choose to use an existing framework, it must not require any components to be installed on the same server as the DB instance. For an example of a sharding solution using an existing framework, see Using an Example of Sharding with Hibernate.
Because of the extensibility limitations of striped storage attached to Windows Server, Amazon RDS doesn’t currently support increasing storage on a SQL Server DB instance. We recommend that you provision storage according to anticipated future storage growth. If you need to increase the storage of a SQL Server DB Instance, you can backup your databases, create a new DB instance with increased storage, and then restore the databases into the new DB instance. For more information, see Importing and Exporting SQL Server Databases.
Amazon RDS doesn’t support some features of SQL Server. This includes components such as SQL Server Analysis Services, SQL Server Integration Services, SQL Server Reporting Services, Data Quality Services, and Master Data Services. To use these features, you can run SQL Server components in an Amazon EC2 instance with Amazon EBS storage, pursuant to Microsoft licensing policies.
Because of limitations in Microsoft SQL Server, restoring to a point in time before successful execution of a DROP DATABASE might not reflect the state of that database at that point in time. For example, the dropped database is typically restored to its state up to 5 minutes before the DROP DATABASE command was issued, which means that you can’t restore the transactions made during those few minutes on your dropped database. To work around this, you can reissue the DROP DATABASE command after the restore operation is completed. Dropping a database removes the transaction logs for that database.

cloudguru

cloudguru

The maximum storage size for a SQL Server DB instance is 4 TB for the Enterprise, Standard, and Web editions, and 300 GB for the Express edition.

Justin Yao

Justin Yao

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