Amazon RDS for SQL Server | General Flashcards

1
Q

What database versions does Amazon RDS for SQL Server support?

General

Amazon RDS for SQL Server | Database

A

Amazon RDS for SQL Server currently supports Microsoft SQL Server 2008 R2, 2012, 2014, 2016, and 2017. Information about the supported minor versions is available in the Amazon RDS User Guide.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Which features are supported by RDS for SQL Server?

General

Amazon RDS for SQL Server | Database

A

You can check the list of supported features in the Amazon RDS User Guide.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

How does Amazon RDS distinguish between “major” and “minor” versions of SQL Server?

General

Amazon RDS for SQL Server | Database

A

In the context of RDS for SQL Server, version number is typically organized as follows:

SQL Server version = X.Y.Z.A.B

X = Major Database version, Z/A/B = Minor Version

For example, 13.00.2164.0.v1 to 13.00.4001.v1 would be a minor version upgrade while 12.00.5000.0.v1 -> 13.00.2164.0.v1 would be a major version upgrade

We follow Microsoft SQL Server conventions in our version names.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Does Amazon RDS provide guidelines for upgrading engine versions or deprecation of engine versions that are currently supported?

General

Amazon RDS for SQL Server | Database

A

Yes. Please refer to the Amazon RDS FAQs.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Why can’t I scale my storage?

General

Amazon RDS for SQL Server | Database

A

Your RDS for SQL Server instance may not be eligible for scaled storage. There are two main reasons why this may happen:

  1. Magnetic Storage types aren’t eligible.
  2. Database instances launched before Jan 1, 2017 might be using an older storage configuration that isn’t eligible.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What can I do if my SQL Server instance isn’t eligible for scaled storage?

General

Amazon RDS for SQL Server | Database

A

You can migrate your existing instance to a new RDS for SQL Server instance, by taking a native backup or using a data migration tool. Make sure the storage type of the new instance is Provisioned IOPS or General Purpose (SSD).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly