Microsoft.Sql locations/instanceFailoverGroups 2023-08-01-preview
- Latest
- 2024-05-01-preview
- 2023-08-01-preview
- 2023-05-01-preview
- 2023-02-01-preview
- 2022-11-01-preview
- 2022-08-01-preview
- 2022-05-01-preview
- 2022-02-01-preview
- 2021-11-01
- 2021-11-01-preview
- 2021-08-01-preview
- 2021-05-01-preview
- 2021-02-01-preview
- 2020-11-01-preview
- 2020-08-01-preview
- 2020-02-02-preview
- 2017-10-01-preview
Bicep resource definition
The locations/instanceFailoverGroups resource type can be deployed with operations that target:
- Resource groups - See resource group deployment commands
For a list of changed properties in each API version, see change log.
Resource format
To create a Microsoft.Sql/locations/instanceFailoverGroups resource, add the following Bicep to your template.
resource symbolicname 'Microsoft.Sql/locations/instanceFailoverGroups@2023-08-01-preview' = {
parent: resourceSymbolicName
name: 'string'
properties: {
managedInstancePairs: [
{
partnerManagedInstanceId: 'string'
primaryManagedInstanceId: 'string'
}
]
partnerRegions: [
{
location: 'string'
}
]
readOnlyEndpoint: {
failoverPolicy: 'string'
}
readWriteEndpoint: {
failoverPolicy: 'string'
failoverWithDataLossGracePeriodMinutes: int
}
secondaryType: 'string'
}
}
Property values
InstanceFailoverGroupProperties
| Name | Description | Value |
|---|---|---|
| managedInstancePairs | List of managed instance pairs in the failover group. | ManagedInstancePairInfo[] (required) |
| partnerRegions | Partner region information for the failover group. | PartnerRegionInfo[] (required) |
| readOnlyEndpoint | Read-only endpoint of the failover group instance. | InstanceFailoverGroupReadOnlyEndpoint |
| readWriteEndpoint | Read-write endpoint of the failover group instance. | InstanceFailoverGroupReadWriteEndpoint (required) |
| secondaryType | Type of the geo-secondary instance. Set 'Standby' if the instance is used as a DR option only. | 'Geo' 'Standby' |
InstanceFailoverGroupReadOnlyEndpoint
| Name | Description | Value |
|---|---|---|
| failoverPolicy | Failover policy of the read-only endpoint for the failover group. | 'Disabled' 'Enabled' |
InstanceFailoverGroupReadWriteEndpoint
| Name | Description | Value |
|---|---|---|
| failoverPolicy | Failover policy of the read-write endpoint for the failover group. If failoverPolicy is Automatic then failoverWithDataLossGracePeriodMinutes is required. | 'Automatic' 'Manual' (required) |
| failoverWithDataLossGracePeriodMinutes | Grace period before failover with data loss is attempted for the read-write endpoint. If failoverPolicy is Automatic then failoverWithDataLossGracePeriodMinutes is required. | int |
ManagedInstancePairInfo
| Name | Description | Value |
|---|---|---|
| partnerManagedInstanceId | Id of Partner Managed Instance in pair. | string |
| primaryManagedInstanceId | Id of Primary Managed Instance in pair. | string |
Microsoft.Sql/locations/instanceFailoverGroups
| Name | Description | Value |
|---|---|---|
| name | The resource name | string (required) |
| parent | In Bicep, you can specify the parent resource for a child resource. You only need to add this property when the child resource is declared outside of the parent resource. For more information, see Child resource outside parent resource. |
Symbolic name for resource of type: locations |
| properties | Resource properties. | InstanceFailoverGroupProperties |
PartnerRegionInfo
| Name | Description | Value |
|---|---|---|
| location | Geo location of the partner managed instances. | string |
ARM template resource definition
The locations/instanceFailoverGroups resource type can be deployed with operations that target:
- Resource groups - See resource group deployment commands
For a list of changed properties in each API version, see change log.
Resource format
To create a Microsoft.Sql/locations/instanceFailoverGroups resource, add the following JSON to your template.
{
"type": "Microsoft.Sql/locations/instanceFailoverGroups",
"apiVersion": "2023-08-01-preview",
"name": "string",
"properties": {
"managedInstancePairs": [
{
"partnerManagedInstanceId": "string",
"primaryManagedInstanceId": "string"
}
],
"partnerRegions": [
{
"location": "string"
}
],
"readOnlyEndpoint": {
"failoverPolicy": "string"
},
"readWriteEndpoint": {
"failoverPolicy": "string",
"failoverWithDataLossGracePeriodMinutes": "int"
},
"secondaryType": "string"
}
}
Property values
InstanceFailoverGroupProperties
| Name | Description | Value |
|---|---|---|
| managedInstancePairs | List of managed instance pairs in the failover group. | ManagedInstancePairInfo[] (required) |
| partnerRegions | Partner region information for the failover group. | PartnerRegionInfo[] (required) |
| readOnlyEndpoint | Read-only endpoint of the failover group instance. | InstanceFailoverGroupReadOnlyEndpoint |
| readWriteEndpoint | Read-write endpoint of the failover group instance. | InstanceFailoverGroupReadWriteEndpoint (required) |
| secondaryType | Type of the geo-secondary instance. Set 'Standby' if the instance is used as a DR option only. | 'Geo' 'Standby' |
InstanceFailoverGroupReadOnlyEndpoint
| Name | Description | Value |
|---|---|---|
| failoverPolicy | Failover policy of the read-only endpoint for the failover group. | 'Disabled' 'Enabled' |
InstanceFailoverGroupReadWriteEndpoint
| Name | Description | Value |
|---|---|---|
| failoverPolicy | Failover policy of the read-write endpoint for the failover group. If failoverPolicy is Automatic then failoverWithDataLossGracePeriodMinutes is required. | 'Automatic' 'Manual' (required) |
| failoverWithDataLossGracePeriodMinutes | Grace period before failover with data loss is attempted for the read-write endpoint. If failoverPolicy is Automatic then failoverWithDataLossGracePeriodMinutes is required. | int |
ManagedInstancePairInfo
| Name | Description | Value |
|---|---|---|
| partnerManagedInstanceId | Id of Partner Managed Instance in pair. | string |
| primaryManagedInstanceId | Id of Primary Managed Instance in pair. | string |
Microsoft.Sql/locations/instanceFailoverGroups
| Name | Description | Value |
|---|---|---|
| apiVersion | The api version | '2023-08-01-preview' |
| name | The resource name | string (required) |
| properties | Resource properties. | InstanceFailoverGroupProperties |
| type | The resource type | 'Microsoft.Sql/locations/instanceFailoverGroups' |
PartnerRegionInfo
| Name | Description | Value |
|---|---|---|
| location | Geo location of the partner managed instances. | string |
Terraform (AzAPI provider) resource definition
The locations/instanceFailoverGroups resource type can be deployed with operations that target:
- Resource groups
For a list of changed properties in each API version, see change log.
Resource format
To create a Microsoft.Sql/locations/instanceFailoverGroups resource, add the following Terraform to your template.
resource "azapi_resource" "symbolicname" {
type = "Microsoft.Sql/locations/instanceFailoverGroups@2023-08-01-preview"
name = "string"
body = jsonencode({
properties = {
managedInstancePairs = [
{
partnerManagedInstanceId = "string"
primaryManagedInstanceId = "string"
}
]
partnerRegions = [
{
location = "string"
}
]
readOnlyEndpoint = {
failoverPolicy = "string"
}
readWriteEndpoint = {
failoverPolicy = "string"
failoverWithDataLossGracePeriodMinutes = int
}
secondaryType = "string"
}
})
}
Property values
InstanceFailoverGroupProperties
| Name | Description | Value |
|---|---|---|
| managedInstancePairs | List of managed instance pairs in the failover group. | ManagedInstancePairInfo[] (required) |
| partnerRegions | Partner region information for the failover group. | PartnerRegionInfo[] (required) |
| readOnlyEndpoint | Read-only endpoint of the failover group instance. | InstanceFailoverGroupReadOnlyEndpoint |
| readWriteEndpoint | Read-write endpoint of the failover group instance. | InstanceFailoverGroupReadWriteEndpoint (required) |
| secondaryType | Type of the geo-secondary instance. Set 'Standby' if the instance is used as a DR option only. | 'Geo' 'Standby' |
InstanceFailoverGroupReadOnlyEndpoint
| Name | Description | Value |
|---|---|---|
| failoverPolicy | Failover policy of the read-only endpoint for the failover group. | 'Disabled' 'Enabled' |
InstanceFailoverGroupReadWriteEndpoint
| Name | Description | Value |
|---|---|---|
| failoverPolicy | Failover policy of the read-write endpoint for the failover group. If failoverPolicy is Automatic then failoverWithDataLossGracePeriodMinutes is required. | 'Automatic' 'Manual' (required) |
| failoverWithDataLossGracePeriodMinutes | Grace period before failover with data loss is attempted for the read-write endpoint. If failoverPolicy is Automatic then failoverWithDataLossGracePeriodMinutes is required. | int |
ManagedInstancePairInfo
| Name | Description | Value |
|---|---|---|
| partnerManagedInstanceId | Id of Partner Managed Instance in pair. | string |
| primaryManagedInstanceId | Id of Primary Managed Instance in pair. | string |
Microsoft.Sql/locations/instanceFailoverGroups
| Name | Description | Value |
|---|---|---|
| name | The resource name | string (required) |
| parent_id | The ID of the resource that is the parent for this resource. | ID for resource of type: locations |
| properties | Resource properties. | InstanceFailoverGroupProperties |
| type | The resource type | "Microsoft.Sql/locations/instanceFailoverGroups@2023-08-01-preview" |
PartnerRegionInfo
| Name | Description | Value |
|---|---|---|
| location | Geo location of the partner managed instances. | string |