Modifying an RDS Custom for SQL Server Multi-AZ deployment to a Single-AZ deployment - Amazon Relational Database Service
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 an RDS Custom for SQL Server Multi-AZ deployment to a Single-AZ deployment

You can modify an existing RDS Custom for SQL Server DB instance from a Multi-AZ to a Single-AZ deployment.

To modify an RDS Custom for SQL Server DB instance from a Multi-AZ to Single-AZ deployment.

  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 Amazon RDS console, choose Databases.

    The Databases pane appears.

  3. Choose the RDS Custom for SQL Server DB instance that you want to modify.

  4. For Multi-AZ deployment, choose No.

  5. On the Confirmation page, choose Apply immediately to apply the changes immediately. Choosing this option doesn't cause downtime, but there is a possible performance impact. Alternatively, you can choose to apply the update during the next maintenance window. For more information, see Using the schedule modifications setting.

  6. On the Confirmation page, choose Modify DB Instance.

To modify a Multi-AZ deployment to a Single-AZ deployment by using the Amazon CLI, call the modify-db-instance command and include the --no-multi-az option. Specify the DB instance identifier and the values for other options that you want to modify. For information about each option, see Settings for DB instances.

Example

The following code modifies mycustomdbinstance by including the --no-multi-az option. The changes are applied during the next maintenance window by using --no-apply-immediately. Use --apply-immediately to apply the changes immediately. For more information, see Using the schedule modifications setting.

For Linux, macOS, or Unix:

aws rds modify-db-instance \
    --db-instance-identifier mycustomdbinstance \
    --no-multi-az  \
    --no-apply-immediately

For Windows:

aws rds modify-db-instance ^
    --db-instance-identifier mycustomdbinstance ^
    --no-multi-az \ ^
    --no-apply-immediately

To modify a Multi-AZ deployment to a Single-AZ deployment by using the RDS API, call the ModifyDBInstance operation and set the MultiAZ parameter to false.