This topic describes how to update the minor engine version of an ApsaraDB RDS for SQL Server instance. These updates are used to enhance database performance, introduce new features, and fix known bugs.

For more information about the minor engine versions of ApsaraDB RDS for SQL Server, see Release notes.

For more information about how to update the minor engine version of an RDS instance that runs a different database engine, see the following topics:

Prerequisites

  • Your RDS instance runs RDS Basic Edition, RDS High-availability Edition, or RDS Enterprise Edition. For more information, see Overview
  • Your RDS instance belongs to the general-purpose instance family or the dedicated instance family. For more information, see ApsaraDB RDS instance families
    Note If your RDS instance belongs to the shared instance family, you cannot update the minor engine version of your RDS instance.

Precautions

  • An update requires 20 minutes to 30 minutes based on the data volume of your RDS instance. We recommend that you perform an update during off-peak hours. In addition, make sure that your application is configured to automatically reconnect to your RDS instance.
  • After you update the minor engine version of your RDS instance, you cannot roll the minor engine version of the RDS instance back to the previous version.
    Warning Before you perform an update, we recommend that you create an RDS instance that is designed to run the destination minor engine version. Then, migrate the data of your RDS instance to the new RDS instance to test overall compatibility. For more information, see Restore data to a new RDS instance
  • After you update the minor engine version of your RDS instance, the value of Backup Size on the Basic Information page of the ApsaraDB RDS console may be displayed as 0. After the next scheduled backup is complete, this error is automatically fixed.

View the minor engine version of your RDS instance

You can use one of the following methods to view the minor engine version of your RDS instance:

Update the minor version of your RDS instance

  1. Access RDS Instances, select a region at the top, and then click the ID of the target RDS instance.
  2. In the Configuration Information section of the page that appears, click Upgrade Minor Engine Version.
    Note If you cannot find where to click Upgrade Minor Engine Version, the minor engine version of your RDS instance is the latest version or your RDS instance does not meet the requirements that are described in Prerequisites.
  3. In the dialog box that appears, configure the Available Upgrade and Upgrade Time parameters. Then, click OK.
    Update the minor version of your RDS instance