Help Center> Relational Database Service> User Guide> Working with RDS for SQL Server> Usage of Stored Procedures> Removing a Custom Database from an Availability Group
Updated on 2023-08-09 GMT+08:00
View PDF

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

You cannot remove system databases. If you attempt to remove a system database, the system displays the following information: 
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';