Removing a Custom Database from an Availability Group

Scenarios

You can use a stored procedure to remove a custom database from the availability group [AG-RDS-YUN].

The stored procedure supports RDS for SQL Server 2017 Enterprise Edition only.

Prerequisites

• An RDS for SQL Server DB instance has been connected. For details about how to connect to a DB instance, see Connecting to a DB Instance.
• The custom database to be removed must have been added to the [AG-RDS-YUN] availability group. If you remove a database that has not been added to the availability group, the system displays the following information:

  Database Database name is not joined to AG-RDS-YUN.

Constraints

Error DBName can not  in ('msdb','master','model','tempdb','rdsadmin','resource') .

Procedure

To remove a custom database from an availability group, run the following command:

EXEC rdsadmin.dbo.rds_remove_database_from_ag '@DBName';

@DBName: specifies the custom database to be removed.

For example, to remove database testDB_1 from the availability group [AG-RDS-YUN], run the following command:

EXEC rdsadmin.dbo.rds_remove_database_from_ag 'testDB_1';