Removing SQL Server databases from availability groups

To remove a SQL Server database from a database availability group (DAG):

  1. In the left pane of the ESI window, select Applications > SQL Server Groups.

  2. In All groups, select the group from which to delete the database.

  3. Click Script Execution and then click Remove Database from Availability Group.

  4. 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.

    1. Click Remove Database.

    2. When the database removed message appears, click OK.

 

Related links

 

 SQL Server Adapter overview

 ESI overview

 Adding SQL Servers

 Home window

 Adding SQL Server replicas

 Adding SQL Server databases to DAGs

 Creating SQL Server databases

 Using T-SQL script