Skip to content

add-elastic-pool-to-failover-group-powershell.md

Latest commit

 

History

History
62 lines (48 loc) · 3.45 KB

add-elastic-pool-to-failover-group-powershell.md

File metadata and controls

62 lines (48 loc) · 3.45 KB
title PowerShell: Add an Elastic Pool to a Failover Group
description Azure PowerShell example script to create an Azure SQL Database elastic pool, add it to a failover group, and test failover.
author rajeshsetlem
ms.author rsetlem
ms.reviewer wiassaf, mathoma
ms.date 06/10/2025
ms.service azure-sql-database
ms.subservice high-availability
ms.topic sample
ms.custom
sqldbrb=1
devx-track-azurepowershell
ms.devlang powershell

Use PowerShell to add an elastic pool to a failover group

[!INCLUDEappliesto-sqldb]

This Azure PowerShell script example creates a database in Azure SQL Database, adds it to an elastic pool, creates a failover group, and tests failover.

[!INCLUDE quickstarts-free-trial-note] [!INCLUDE updated-for-az] [!INCLUDE cloud-shell-try-it.md]

If you choose to install and use PowerShell locally, this tutorial requires Az PowerShell 1.4.0 or later. If you need to upgrade, see Install Azure PowerShell module. If you are running PowerShell locally, you also need to run Connect-AzAccount to create a connection with Azure.

Sample scripts

[!code-powershell-interactivemain]

Clean up deployment

Use the following command to remove the resource group and all resources associated with it.

Remove-AzResourceGroup -ResourceGroupName $resourceGroupName

Script explanation

This script uses the following commands. Each command in the table links to command-specific documentation.

Command Notes
New-AzResourceGroup Creates a resource group in which all resources are stored.
New-AzSqlServer Creates a server that hosts databases and elastic pools.
New-AzSqlServerFirewallRule Creates a server-level firewall rule for a server.
New-AzSqlDatabase Creates a new database.
New-AzSqlElasticPool Creates an elastic database pool.
Set-AzSqlDatabase Sets properties for a database, or moves an existing database into an elastic pool.
New-AzSqlDatabaseFailoverGroup Creates a new failover group.
Get-AzSqlDatabase Gets one or more databases.
Add-AzSqlDatabaseToFailoverGroup Adds one or more databases to a failover group.
Get-AzSqlDatabaseFailoverGroup Gets or lists database failover groups.
Switch-AzSqlDatabaseFailoverGroup Executes a failover of a database failover group.
Remove-AzResourceGroup Removes a resource group

Related content