ElasticPools(Failover) - Failover

Failovers an elastic pool.

POST https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/elasticPools/{elasticPoolName}/failover?api-version=2018-06-01-preview

URI Parameters

Name In Required Type Description
path True
  • string

The subscription ID that identifies an Azure subscription.

path True
  • string

The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

path True
  • string

The name of the server.

path True
  • string

The name of the elastic pool to failover.

query True
  • string

The API version to use for the request.


Name Type Description
200 OK

Successfully completed elastic pool failover.

202 Accepted

Elastic pool failover is in progress.

Other Status Codes

*** Error Responses: ***

  • 400 ManagementServiceFeatureDisabled - User attempted to use a feature which is disabled.

  • 400 ElasticPoolFailoverThrottled - There was a recent failover on the elastic pool.

  • 400 ElasticPoolFailoverNotSupportedOnSKU - This type of customer initiated failover is not supported on the given SKU.

  • 409 ManagementServiceDatabaseBusy - Database '{0}' is busy with another operation. Please try your operation later.

  • 409 ElasticPoolNotInStateToFailover - The elastic pool or a database within the elastic pool is currently in a state such that failover cannot be issued.


Failover an elastic pool

Sample Request

POST https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/group1/providers/Microsoft.Sql/servers/testServer/elasticPools/testElasticPool/failover?api-version=2018-06-01-preview

Sample Response