Modifying a CEV for RDS Custom for SQL Server - Amazon Relational Database Service
Modifying an RDS Custom for SQL Server DB instance to use a new CEV
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Modifying a CEV for RDS Custom for SQL Server

You can modify a CEV using the Amazon Web Services Management Console or the Amazon CLI. You can modify the CEV description or its availability status. Your CEV has one of the following status values:

  • available – You can use this CEV to create a new RDS Custom DB instance or upgrade a DB instance. This is the default status for a newly created CEV.

  • inactive – You can't create or upgrade an RDS Custom DB instance with this CEV. You can't restore a DB snapshot to create a new RDS Custom DB instance with this CEV.

You can change the CEV status from available to inactive or from inactive to available. You might change the status to INACTIVE to prevent the accidental use of a CEV or to make a discontinued CEV eligible for use again.

To modify a CEV

  1. Sign in to the Amazon Web Services Management Console and open the Amazon RDS console at https://console.amazonaws.cn/rds/.

  2. In the navigation pane, choose Custom engine versions.

  3. Choose a CEV whose description or status you want to modify.

  4. For Actions, choose Modify.

  5. Make any of the following changes:

    • For CEV status settings, choose a new availability status.

    • For Version description, enter a new description.

  6. Choose Modify CEV.

    If the CEV is in use, the console displays You can't modify the CEV status. Fix the problems, then try again.

The Custom engine versions page appears.

To modify a CEV by using the Amazon CLI, run the modify-custom-db-engine-version command. You can find CEVs to modify by running the describe-db-engine-versions command.

The following options are required:

  • --engine

  • --engine-version cev, where cev is the name of the custom engine version that you want to modify

  • --status status, where status is the availability status that you want to assign to the CEV

The following example changes a CEV named 15.00.4249.2.my_cevtest from its current status to inactive.

For Linux, macOS, or Unix:

aws rds modify-custom-db-engine-version \
    --engine custom-sqlserver-ee \ 
    --engine-version 15.00.4249.2.my_cevtest \
    --status inactive

For Windows:

aws rds modify-custom-db-engine-version ^
    --engine custom-sqlserver-ee ^
    --engine-version 15.00.4249.2.my_cevtest ^
    --status inactive

Modifying an RDS Custom for SQL Server DB instance to use a new CEV

You can modify an existing RDS Custom for SQL Server DB instance to use a different CEV. The changes that you can make include:

  • Changing the CEV

  • Changing the DB instance class

  • Changing the backup retention period and backup window

  • Changing the maintenance window

To modify an RDS Custom for SQL Server DB instance

  1. Sign in to the Amazon Web Services Management Console and open the Amazon RDS console at https://console.amazonaws.cn/rds/.

  2. In the navigation pane, choose Databases.

  3. Choose the DB instance that you want to modify.

  4. Choose Modify.

  5. Make the following changes as needed:

    1. For DB engine version, choose a different CEV.

    2. Change the value for DB instance class. For supported classes, see DB instance class support for RDS Custom for SQL Server.

    3. Change the value for Backup retention period.

    4. For Backup window, set values for the Start time and Duration.

    5. For DB instance maintenance window, set values for the Start day, Start time, and Duration.

  6. Choose Continue.

  7. Choose Apply immediately or Apply during the next scheduled maintenance window.

  8. Choose Modify DB instance.

    Note

    When modifying a DB instance from one CEV to an another CEV, for example, when upgrading a minor version, the SQL Server system databases, including their data and configurations, are persisted from the current RDS Custom for SQL Server DB instance.

To modify a DB instance to use a different CEV by using the Amazon CLI, run the modify-db-instance command.

The following options are required:

  • --db-instance-identifier

  • --engine-version cev, where cev is the name of the custom engine version that you want the DB instance to change to.

The following example modifies a DB instance named my-cev-db-instance to use a CEV named 15.00.4249.2.my_cevtest_new and applies the change immediately.

For Linux, macOS, or Unix:

aws rds modify-db-instance \
    --db-instance-identifier my-cev-db-instance \ 
    --engine-version 15.00.4249.2.my_cevtest_new \
    --apply-immediately

For Windows:

aws rds modify-db-instance ^
    --db-instance-identifier my-cev-db-instance ^
    --engine-version 15.00.4249.2.my_cevtest_new ^
    --apply-immediately