Databases - Failover
Failovers a database.
POST https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/failover?api-version=2021-11-01
POST https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/failover?replicaType={replicaType}&api-version=2021-11-01
URI Parameters
Name | In | Required | Type | Description |
---|---|---|---|---|
database
|
path | True |
string |
The name of the database to failover. |
resource
|
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. |
server
|
path | True |
string |
The name of the server. |
subscription
|
path | True |
string |
The subscription ID that identifies an Azure subscription. |
api-version
|
query | True |
string |
The API version to use for the request. |
replica
|
query |
The type of replica to be failed over. |
Responses
Name | Type | Description |
---|---|---|
200 OK |
Successfully completed database failover. |
|
202 Accepted |
Database failover is in progress. |
|
Other Status Codes |
*** Error Responses: ***
|
Examples
Failover an database
Sample request
Sample response
Definitions
ReplicaType
The type of replica to be failed over.
Name | Type | Description |
---|---|---|
Primary |
string |
|
ReadableSecondary |
string |