Removing a Custom Database from an Availability Group

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

Note

An RDS for SQL Server DB instance has been connected. .
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.
```

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') .

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';

Была ли эта статья полезна?