1. Packages
  2. Azure Classic
  3. API Docs
  4. mssql
  5. FailoverGroup

We recommend using Azure Native.

Azure Classic v5.43.0 published on Saturday, May 6, 2023 by Pulumi

azure.mssql.FailoverGroup

Explore with Pulumi AI

azure logo

We recommend using Azure Native.

Azure Classic v5.43.0 published on Saturday, May 6, 2023 by Pulumi

    Manages a Microsoft Azure SQL Failover Group.

    Example Usage

    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using Azure = Pulumi.Azure;
    
    return await Deployment.RunAsync(() => 
    {
        var exampleResourceGroup = new Azure.Core.ResourceGroup("exampleResourceGroup", new()
        {
            Location = "West Europe",
        });
    
        var primary = new Azure.MSSql.Server("primary", new()
        {
            ResourceGroupName = exampleResourceGroup.Name,
            Location = exampleResourceGroup.Location,
            Version = "12.0",
            AdministratorLogin = "missadministrator",
            AdministratorLoginPassword = "thisIsKat11",
        });
    
        var secondary = new Azure.MSSql.Server("secondary", new()
        {
            ResourceGroupName = exampleResourceGroup.Name,
            Location = exampleResourceGroup.Location,
            Version = "12.0",
            AdministratorLogin = "missadministrator",
            AdministratorLoginPassword = "thisIsKat12",
        });
    
        var exampleDatabase = new Azure.MSSql.Database("exampleDatabase", new()
        {
            ServerId = primary.Id,
            SkuName = "S1",
            Collation = "SQL_Latin1_General_CP1_CI_AS",
            MaxSizeGb = 200,
        });
    
        var exampleFailoverGroup = new Azure.MSSql.FailoverGroup("exampleFailoverGroup", new()
        {
            ServerId = primary.Id,
            Databases = new[]
            {
                exampleDatabase.Id,
            },
            PartnerServers = new[]
            {
                new Azure.MSSql.Inputs.FailoverGroupPartnerServerArgs
                {
                    Id = secondary.Id,
                },
            },
            ReadWriteEndpointFailoverPolicy = new Azure.MSSql.Inputs.FailoverGroupReadWriteEndpointFailoverPolicyArgs
            {
                Mode = "Automatic",
                GraceMinutes = 80,
            },
            Tags = 
            {
                { "environment", "prod" },
                { "database", "example" },
            },
        });
    
    });
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-azure/sdk/v5/go/azure/core"
    	"github.com/pulumi/pulumi-azure/sdk/v5/go/azure/mssql"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		exampleResourceGroup, err := core.NewResourceGroup(ctx, "exampleResourceGroup", &core.ResourceGroupArgs{
    			Location: pulumi.String("West Europe"),
    		})
    		if err != nil {
    			return err
    		}
    		primary, err := mssql.NewServer(ctx, "primary", &mssql.ServerArgs{
    			ResourceGroupName:          exampleResourceGroup.Name,
    			Location:                   exampleResourceGroup.Location,
    			Version:                    pulumi.String("12.0"),
    			AdministratorLogin:         pulumi.String("missadministrator"),
    			AdministratorLoginPassword: pulumi.String("thisIsKat11"),
    		})
    		if err != nil {
    			return err
    		}
    		secondary, err := mssql.NewServer(ctx, "secondary", &mssql.ServerArgs{
    			ResourceGroupName:          exampleResourceGroup.Name,
    			Location:                   exampleResourceGroup.Location,
    			Version:                    pulumi.String("12.0"),
    			AdministratorLogin:         pulumi.String("missadministrator"),
    			AdministratorLoginPassword: pulumi.String("thisIsKat12"),
    		})
    		if err != nil {
    			return err
    		}
    		exampleDatabase, err := mssql.NewDatabase(ctx, "exampleDatabase", &mssql.DatabaseArgs{
    			ServerId:  primary.ID(),
    			SkuName:   pulumi.String("S1"),
    			Collation: pulumi.String("SQL_Latin1_General_CP1_CI_AS"),
    			MaxSizeGb: pulumi.Int(200),
    		})
    		if err != nil {
    			return err
    		}
    		_, err = mssql.NewFailoverGroup(ctx, "exampleFailoverGroup", &mssql.FailoverGroupArgs{
    			ServerId: primary.ID(),
    			Databases: pulumi.StringArray{
    				exampleDatabase.ID(),
    			},
    			PartnerServers: mssql.FailoverGroupPartnerServerArray{
    				&mssql.FailoverGroupPartnerServerArgs{
    					Id: secondary.ID(),
    				},
    			},
    			ReadWriteEndpointFailoverPolicy: &mssql.FailoverGroupReadWriteEndpointFailoverPolicyArgs{
    				Mode:         pulumi.String("Automatic"),
    				GraceMinutes: pulumi.Int(80),
    			},
    			Tags: pulumi.StringMap{
    				"environment": pulumi.String("prod"),
    				"database":    pulumi.String("example"),
    			},
    		})
    		if err != nil {
    			return err
    		}
    		return nil
    	})
    }
    
    package generated_program;
    
    import com.pulumi.Context;
    import com.pulumi.Pulumi;
    import com.pulumi.core.Output;
    import com.pulumi.azure.core.ResourceGroup;
    import com.pulumi.azure.core.ResourceGroupArgs;
    import com.pulumi.azure.mssql.Server;
    import com.pulumi.azure.mssql.ServerArgs;
    import com.pulumi.azure.mssql.Database;
    import com.pulumi.azure.mssql.DatabaseArgs;
    import com.pulumi.azure.mssql.FailoverGroup;
    import com.pulumi.azure.mssql.FailoverGroupArgs;
    import com.pulumi.azure.mssql.inputs.FailoverGroupPartnerServerArgs;
    import com.pulumi.azure.mssql.inputs.FailoverGroupReadWriteEndpointFailoverPolicyArgs;
    import java.util.List;
    import java.util.ArrayList;
    import java.util.Map;
    import java.io.File;
    import java.nio.file.Files;
    import java.nio.file.Paths;
    
    public class App {
        public static void main(String[] args) {
            Pulumi.run(App::stack);
        }
    
        public static void stack(Context ctx) {
            var exampleResourceGroup = new ResourceGroup("exampleResourceGroup", ResourceGroupArgs.builder()        
                .location("West Europe")
                .build());
    
            var primary = new Server("primary", ServerArgs.builder()        
                .resourceGroupName(exampleResourceGroup.name())
                .location(exampleResourceGroup.location())
                .version("12.0")
                .administratorLogin("missadministrator")
                .administratorLoginPassword("thisIsKat11")
                .build());
    
            var secondary = new Server("secondary", ServerArgs.builder()        
                .resourceGroupName(exampleResourceGroup.name())
                .location(exampleResourceGroup.location())
                .version("12.0")
                .administratorLogin("missadministrator")
                .administratorLoginPassword("thisIsKat12")
                .build());
    
            var exampleDatabase = new Database("exampleDatabase", DatabaseArgs.builder()        
                .serverId(primary.id())
                .skuName("S1")
                .collation("SQL_Latin1_General_CP1_CI_AS")
                .maxSizeGb("200")
                .build());
    
            var exampleFailoverGroup = new FailoverGroup("exampleFailoverGroup", FailoverGroupArgs.builder()        
                .serverId(primary.id())
                .databases(exampleDatabase.id())
                .partnerServers(FailoverGroupPartnerServerArgs.builder()
                    .id(secondary.id())
                    .build())
                .readWriteEndpointFailoverPolicy(FailoverGroupReadWriteEndpointFailoverPolicyArgs.builder()
                    .mode("Automatic")
                    .graceMinutes(80)
                    .build())
                .tags(Map.ofEntries(
                    Map.entry("environment", "prod"),
                    Map.entry("database", "example")
                ))
                .build());
    
        }
    }
    
    import pulumi
    import pulumi_azure as azure
    
    example_resource_group = azure.core.ResourceGroup("exampleResourceGroup", location="West Europe")
    primary = azure.mssql.Server("primary",
        resource_group_name=example_resource_group.name,
        location=example_resource_group.location,
        version="12.0",
        administrator_login="missadministrator",
        administrator_login_password="thisIsKat11")
    secondary = azure.mssql.Server("secondary",
        resource_group_name=example_resource_group.name,
        location=example_resource_group.location,
        version="12.0",
        administrator_login="missadministrator",
        administrator_login_password="thisIsKat12")
    example_database = azure.mssql.Database("exampleDatabase",
        server_id=primary.id,
        sku_name="S1",
        collation="SQL_Latin1_General_CP1_CI_AS",
        max_size_gb=200)
    example_failover_group = azure.mssql.FailoverGroup("exampleFailoverGroup",
        server_id=primary.id,
        databases=[example_database.id],
        partner_servers=[azure.mssql.FailoverGroupPartnerServerArgs(
            id=secondary.id,
        )],
        read_write_endpoint_failover_policy=azure.mssql.FailoverGroupReadWriteEndpointFailoverPolicyArgs(
            mode="Automatic",
            grace_minutes=80,
        ),
        tags={
            "environment": "prod",
            "database": "example",
        })
    
    import * as pulumi from "@pulumi/pulumi";
    import * as azure from "@pulumi/azure";
    
    const exampleResourceGroup = new azure.core.ResourceGroup("exampleResourceGroup", {location: "West Europe"});
    const primary = new azure.mssql.Server("primary", {
        resourceGroupName: exampleResourceGroup.name,
        location: exampleResourceGroup.location,
        version: "12.0",
        administratorLogin: "missadministrator",
        administratorLoginPassword: "thisIsKat11",
    });
    const secondary = new azure.mssql.Server("secondary", {
        resourceGroupName: exampleResourceGroup.name,
        location: exampleResourceGroup.location,
        version: "12.0",
        administratorLogin: "missadministrator",
        administratorLoginPassword: "thisIsKat12",
    });
    const exampleDatabase = new azure.mssql.Database("exampleDatabase", {
        serverId: primary.id,
        skuName: "S1",
        collation: "SQL_Latin1_General_CP1_CI_AS",
        maxSizeGb: 200,
    });
    const exampleFailoverGroup = new azure.mssql.FailoverGroup("exampleFailoverGroup", {
        serverId: primary.id,
        databases: [exampleDatabase.id],
        partnerServers: [{
            id: secondary.id,
        }],
        readWriteEndpointFailoverPolicy: {
            mode: "Automatic",
            graceMinutes: 80,
        },
        tags: {
            environment: "prod",
            database: "example",
        },
    });
    
    resources:
      exampleResourceGroup:
        type: azure:core:ResourceGroup
        properties:
          location: West Europe
      primary:
        type: azure:mssql:Server
        properties:
          resourceGroupName: ${exampleResourceGroup.name}
          location: ${exampleResourceGroup.location}
          version: '12.0'
          administratorLogin: missadministrator
          administratorLoginPassword: thisIsKat11
      secondary:
        type: azure:mssql:Server
        properties:
          resourceGroupName: ${exampleResourceGroup.name}
          location: ${exampleResourceGroup.location}
          version: '12.0'
          administratorLogin: missadministrator
          administratorLoginPassword: thisIsKat12
      exampleDatabase:
        type: azure:mssql:Database
        properties:
          serverId: ${primary.id}
          skuName: S1
          collation: SQL_Latin1_General_CP1_CI_AS
          maxSizeGb: '200'
      exampleFailoverGroup:
        type: azure:mssql:FailoverGroup
        properties:
          serverId: ${primary.id}
          databases:
            - ${exampleDatabase.id}
          partnerServers:
            - id: ${secondary.id}
          readWriteEndpointFailoverPolicy:
            mode: Automatic
            graceMinutes: 80
          tags:
            environment: prod
            database: example
    

    Create FailoverGroup Resource

    new FailoverGroup(name: string, args: FailoverGroupArgs, opts?: CustomResourceOptions);
    @overload
    def FailoverGroup(resource_name: str,
                      opts: Optional[ResourceOptions] = None,
                      databases: Optional[Sequence[str]] = None,
                      name: Optional[str] = None,
                      partner_servers: Optional[Sequence[FailoverGroupPartnerServerArgs]] = None,
                      read_write_endpoint_failover_policy: Optional[FailoverGroupReadWriteEndpointFailoverPolicyArgs] = None,
                      readonly_endpoint_failover_policy_enabled: Optional[bool] = None,
                      server_id: Optional[str] = None,
                      tags: Optional[Mapping[str, str]] = None)
    @overload
    def FailoverGroup(resource_name: str,
                      args: FailoverGroupArgs,
                      opts: Optional[ResourceOptions] = None)
    func NewFailoverGroup(ctx *Context, name string, args FailoverGroupArgs, opts ...ResourceOption) (*FailoverGroup, error)
    public FailoverGroup(string name, FailoverGroupArgs args, CustomResourceOptions? opts = null)
    public FailoverGroup(String name, FailoverGroupArgs args)
    public FailoverGroup(String name, FailoverGroupArgs args, CustomResourceOptions options)
    
    type: azure:mssql:FailoverGroup
    properties: # The arguments to resource properties.
    options: # Bag of options to control resource's behavior.
    
    
    name string
    The unique name of the resource.
    args FailoverGroupArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    resource_name str
    The unique name of the resource.
    args FailoverGroupArgs
    The arguments to resource properties.
    opts ResourceOptions
    Bag of options to control resource's behavior.
    ctx Context
    Context object for the current deployment.
    name string
    The unique name of the resource.
    args FailoverGroupArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args FailoverGroupArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args FailoverGroupArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    FailoverGroup Resource Properties

    To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

    Inputs

    The FailoverGroup resource accepts the following input properties:

    PartnerServers List<FailoverGroupPartnerServerArgs>

    A partner_server block as defined below.

    ReadWriteEndpointFailoverPolicy FailoverGroupReadWriteEndpointFailoverPolicyArgs

    A read_write_endpoint_failover_policy block as defined below.

    ServerId string

    The ID of the primary SQL Server on which to create the failover group. Changing this forces a new resource to be created.

    Databases List<string>

    A set of database names to include in the failover group.

    Name string

    The name of the Failover Group. Changing this forces a new resource to be created.

    ReadonlyEndpointFailoverPolicyEnabled bool

    Whether failover is enabled for the readonly endpoint. Defaults to false.

    Tags Dictionary<string, string>

    A mapping of tags to assign to the resource.

    PartnerServers []FailoverGroupPartnerServerArgs

    A partner_server block as defined below.

    ReadWriteEndpointFailoverPolicy FailoverGroupReadWriteEndpointFailoverPolicyArgs

    A read_write_endpoint_failover_policy block as defined below.

    ServerId string

    The ID of the primary SQL Server on which to create the failover group. Changing this forces a new resource to be created.

    Databases []string

    A set of database names to include in the failover group.

    Name string

    The name of the Failover Group. Changing this forces a new resource to be created.

    ReadonlyEndpointFailoverPolicyEnabled bool

    Whether failover is enabled for the readonly endpoint. Defaults to false.

    Tags map[string]string

    A mapping of tags to assign to the resource.

    partnerServers List<FailoverGroupPartnerServerArgs>

    A partner_server block as defined below.

    readWriteEndpointFailoverPolicy FailoverGroupReadWriteEndpointFailoverPolicyArgs

    A read_write_endpoint_failover_policy block as defined below.

    serverId String

    The ID of the primary SQL Server on which to create the failover group. Changing this forces a new resource to be created.

    databases List<String>

    A set of database names to include in the failover group.

    name String

    The name of the Failover Group. Changing this forces a new resource to be created.

    readonlyEndpointFailoverPolicyEnabled Boolean

    Whether failover is enabled for the readonly endpoint. Defaults to false.

    tags Map<String,String>

    A mapping of tags to assign to the resource.

    partnerServers FailoverGroupPartnerServerArgs[]

    A partner_server block as defined below.

    readWriteEndpointFailoverPolicy FailoverGroupReadWriteEndpointFailoverPolicyArgs

    A read_write_endpoint_failover_policy block as defined below.

    serverId string

    The ID of the primary SQL Server on which to create the failover group. Changing this forces a new resource to be created.

    databases string[]

    A set of database names to include in the failover group.

    name string

    The name of the Failover Group. Changing this forces a new resource to be created.

    readonlyEndpointFailoverPolicyEnabled boolean

    Whether failover is enabled for the readonly endpoint. Defaults to false.

    tags {[key: string]: string}

    A mapping of tags to assign to the resource.

    partner_servers Sequence[FailoverGroupPartnerServerArgs]

    A partner_server block as defined below.

    read_write_endpoint_failover_policy FailoverGroupReadWriteEndpointFailoverPolicyArgs

    A read_write_endpoint_failover_policy block as defined below.

    server_id str

    The ID of the primary SQL Server on which to create the failover group. Changing this forces a new resource to be created.

    databases Sequence[str]

    A set of database names to include in the failover group.

    name str

    The name of the Failover Group. Changing this forces a new resource to be created.

    readonly_endpoint_failover_policy_enabled bool

    Whether failover is enabled for the readonly endpoint. Defaults to false.

    tags Mapping[str, str]

    A mapping of tags to assign to the resource.

    partnerServers List<Property Map>

    A partner_server block as defined below.

    readWriteEndpointFailoverPolicy Property Map

    A read_write_endpoint_failover_policy block as defined below.

    serverId String

    The ID of the primary SQL Server on which to create the failover group. Changing this forces a new resource to be created.

    databases List<String>

    A set of database names to include in the failover group.

    name String

    The name of the Failover Group. Changing this forces a new resource to be created.

    readonlyEndpointFailoverPolicyEnabled Boolean

    Whether failover is enabled for the readonly endpoint. Defaults to false.

    tags Map<String>

    A mapping of tags to assign to the resource.

    Outputs

    All input properties are implicitly available as output properties. Additionally, the FailoverGroup resource produces the following output properties:

    Id string

    The provider-assigned unique ID for this managed resource.

    Id string

    The provider-assigned unique ID for this managed resource.

    id String

    The provider-assigned unique ID for this managed resource.

    id string

    The provider-assigned unique ID for this managed resource.

    id str

    The provider-assigned unique ID for this managed resource.

    id String

    The provider-assigned unique ID for this managed resource.

    Look up Existing FailoverGroup Resource

    Get an existing FailoverGroup resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

    public static get(name: string, id: Input<ID>, state?: FailoverGroupState, opts?: CustomResourceOptions): FailoverGroup
    @staticmethod
    def get(resource_name: str,
            id: str,
            opts: Optional[ResourceOptions] = None,
            databases: Optional[Sequence[str]] = None,
            name: Optional[str] = None,
            partner_servers: Optional[Sequence[FailoverGroupPartnerServerArgs]] = None,
            read_write_endpoint_failover_policy: Optional[FailoverGroupReadWriteEndpointFailoverPolicyArgs] = None,
            readonly_endpoint_failover_policy_enabled: Optional[bool] = None,
            server_id: Optional[str] = None,
            tags: Optional[Mapping[str, str]] = None) -> FailoverGroup
    func GetFailoverGroup(ctx *Context, name string, id IDInput, state *FailoverGroupState, opts ...ResourceOption) (*FailoverGroup, error)
    public static FailoverGroup Get(string name, Input<string> id, FailoverGroupState? state, CustomResourceOptions? opts = null)
    public static FailoverGroup get(String name, Output<String> id, FailoverGroupState state, CustomResourceOptions options)
    Resource lookup is not supported in YAML
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    resource_name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    The following state arguments are supported:
    Databases List<string>

    A set of database names to include in the failover group.

    Name string

    The name of the Failover Group. Changing this forces a new resource to be created.

    PartnerServers List<FailoverGroupPartnerServerArgs>

    A partner_server block as defined below.

    ReadWriteEndpointFailoverPolicy FailoverGroupReadWriteEndpointFailoverPolicyArgs

    A read_write_endpoint_failover_policy block as defined below.

    ReadonlyEndpointFailoverPolicyEnabled bool

    Whether failover is enabled for the readonly endpoint. Defaults to false.

    ServerId string

    The ID of the primary SQL Server on which to create the failover group. Changing this forces a new resource to be created.

    Tags Dictionary<string, string>

    A mapping of tags to assign to the resource.

    Databases []string

    A set of database names to include in the failover group.

    Name string

    The name of the Failover Group. Changing this forces a new resource to be created.

    PartnerServers []FailoverGroupPartnerServerArgs

    A partner_server block as defined below.

    ReadWriteEndpointFailoverPolicy FailoverGroupReadWriteEndpointFailoverPolicyArgs

    A read_write_endpoint_failover_policy block as defined below.

    ReadonlyEndpointFailoverPolicyEnabled bool

    Whether failover is enabled for the readonly endpoint. Defaults to false.

    ServerId string

    The ID of the primary SQL Server on which to create the failover group. Changing this forces a new resource to be created.

    Tags map[string]string

    A mapping of tags to assign to the resource.

    databases List<String>

    A set of database names to include in the failover group.

    name String

    The name of the Failover Group. Changing this forces a new resource to be created.

    partnerServers List<FailoverGroupPartnerServerArgs>

    A partner_server block as defined below.

    readWriteEndpointFailoverPolicy FailoverGroupReadWriteEndpointFailoverPolicyArgs

    A read_write_endpoint_failover_policy block as defined below.

    readonlyEndpointFailoverPolicyEnabled Boolean

    Whether failover is enabled for the readonly endpoint. Defaults to false.

    serverId String

    The ID of the primary SQL Server on which to create the failover group. Changing this forces a new resource to be created.

    tags Map<String,String>

    A mapping of tags to assign to the resource.

    databases string[]

    A set of database names to include in the failover group.

    name string

    The name of the Failover Group. Changing this forces a new resource to be created.

    partnerServers FailoverGroupPartnerServerArgs[]

    A partner_server block as defined below.

    readWriteEndpointFailoverPolicy FailoverGroupReadWriteEndpointFailoverPolicyArgs

    A read_write_endpoint_failover_policy block as defined below.

    readonlyEndpointFailoverPolicyEnabled boolean

    Whether failover is enabled for the readonly endpoint. Defaults to false.

    serverId string

    The ID of the primary SQL Server on which to create the failover group. Changing this forces a new resource to be created.

    tags {[key: string]: string}

    A mapping of tags to assign to the resource.

    databases Sequence[str]

    A set of database names to include in the failover group.

    name str

    The name of the Failover Group. Changing this forces a new resource to be created.

    partner_servers Sequence[FailoverGroupPartnerServerArgs]

    A partner_server block as defined below.

    read_write_endpoint_failover_policy FailoverGroupReadWriteEndpointFailoverPolicyArgs

    A read_write_endpoint_failover_policy block as defined below.

    readonly_endpoint_failover_policy_enabled bool

    Whether failover is enabled for the readonly endpoint. Defaults to false.

    server_id str

    The ID of the primary SQL Server on which to create the failover group. Changing this forces a new resource to be created.

    tags Mapping[str, str]

    A mapping of tags to assign to the resource.

    databases List<String>

    A set of database names to include in the failover group.

    name String

    The name of the Failover Group. Changing this forces a new resource to be created.

    partnerServers List<Property Map>

    A partner_server block as defined below.

    readWriteEndpointFailoverPolicy Property Map

    A read_write_endpoint_failover_policy block as defined below.

    readonlyEndpointFailoverPolicyEnabled Boolean

    Whether failover is enabled for the readonly endpoint. Defaults to false.

    serverId String

    The ID of the primary SQL Server on which to create the failover group. Changing this forces a new resource to be created.

    tags Map<String>

    A mapping of tags to assign to the resource.

    Supporting Types

    FailoverGroupPartnerServer

    Id string

    The ID of a partner SQL server to include in the failover group.

    Location string

    The location of the partner server.

    Role string

    The replication role of the partner server. Possible values include Primary or Secondary.

    Id string

    The ID of a partner SQL server to include in the failover group.

    Location string

    The location of the partner server.

    Role string

    The replication role of the partner server. Possible values include Primary or Secondary.

    id String

    The ID of a partner SQL server to include in the failover group.

    location String

    The location of the partner server.

    role String

    The replication role of the partner server. Possible values include Primary or Secondary.

    id string

    The ID of a partner SQL server to include in the failover group.

    location string

    The location of the partner server.

    role string

    The replication role of the partner server. Possible values include Primary or Secondary.

    id str

    The ID of a partner SQL server to include in the failover group.

    location str

    The location of the partner server.

    role str

    The replication role of the partner server. Possible values include Primary or Secondary.

    id String

    The ID of a partner SQL server to include in the failover group.

    location String

    The location of the partner server.

    role String

    The replication role of the partner server. Possible values include Primary or Secondary.

    FailoverGroupReadWriteEndpointFailoverPolicy

    Mode string

    The failover policy of the read-write endpoint for the failover group. Possible values are Automatic or Manual.

    GraceMinutes int

    The grace period in minutes, before failover with data loss is attempted for the read-write endpoint. Required when mode is Automatic.

    Mode string

    The failover policy of the read-write endpoint for the failover group. Possible values are Automatic or Manual.

    GraceMinutes int

    The grace period in minutes, before failover with data loss is attempted for the read-write endpoint. Required when mode is Automatic.

    mode String

    The failover policy of the read-write endpoint for the failover group. Possible values are Automatic or Manual.

    graceMinutes Integer

    The grace period in minutes, before failover with data loss is attempted for the read-write endpoint. Required when mode is Automatic.

    mode string

    The failover policy of the read-write endpoint for the failover group. Possible values are Automatic or Manual.

    graceMinutes number

    The grace period in minutes, before failover with data loss is attempted for the read-write endpoint. Required when mode is Automatic.

    mode str

    The failover policy of the read-write endpoint for the failover group. Possible values are Automatic or Manual.

    grace_minutes int

    The grace period in minutes, before failover with data loss is attempted for the read-write endpoint. Required when mode is Automatic.

    mode String

    The failover policy of the read-write endpoint for the failover group. Possible values are Automatic or Manual.

    graceMinutes Number

    The grace period in minutes, before failover with data loss is attempted for the read-write endpoint. Required when mode is Automatic.

    Import

    Failover Groups can be imported using the resource id, e.g.

     $ pulumi import azure:mssql/failoverGroup:FailoverGroup example /subscriptions/12345678-1234-9876-4563-123456789012/resourceGroups/resGroup1/providers/Microsoft.Sql/servers/server1/failoverGroups/failoverGroup1
    

    Package Details

    Repository
    Azure Classic pulumi/pulumi-azure
    License
    Apache-2.0
    Notes

    This Pulumi package is based on the azurerm Terraform Provider.

    azure logo

    We recommend using Azure Native.

    Azure Classic v5.43.0 published on Saturday, May 6, 2023 by Pulumi