To remove a SQL Server database from a database availability group (DAG):
In the left pane of the ESI window, select Applications > SQL Server Groups.
In All groups, select the group from which to delete the database.
Click Script Execution and then click Remove Database from Availability Group.
In the Remove Database from Availability Group page, confirm or select the following.
Field |
Description |
Server |
SQL Server in the availability group |
Instance |
SQL Server instance in the availability group |
Availability Group |
Availability group from which to remove the database |
Availability Database |
Database to remove from the group. |
Shared Network Location |
Browse to select the folder or type the shared folder path for the group. |
Show script |
Select to show the T-SQL script, which appears after removing the database. |
Click Remove Database.
When the database removed message appears, click OK.