pulumi-azure-native-kotlin/com.pulumi.azurenative.azurearcdata.kotlin/SqlServerAvailabilityGroup

SqlServerAvailabilityGroup

class SqlServerAvailabilityGroup : KotlinCustomResource

Arc Sql Server Availability Group Uses Azure REST API version 2024-01-01. Other available API versions: 2024-05-01-preview, 2025-03-01-preview.

Example Usage

Create a Arc Sql Server availability group.

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
    var sqlServerAvailabilityGroup = new AzureNative.AzureArcData.SqlServerAvailabilityGroup("sqlServerAvailabilityGroup", new()
    {
        AvailabilityGroupName = "testAG",
        Location = "southeastasia",
        Properties = new AzureNative.AzureArcData.Inputs.SqlServerAvailabilityGroupResourcePropertiesArgs
        {
            Databases = new AzureNative.AzureArcData.Inputs.SqlServerAvailabilityGroupResourcePropertiesDatabasesArgs
            {
                Value = new[]
                {
                    new AzureNative.AzureArcData.Inputs.SqlAvailabilityGroupDatabaseReplicaResourcePropertiesArgs
                    {
                        DatabaseName = "db1",
                    },
                    new AzureNative.AzureArcData.Inputs.SqlAvailabilityGroupDatabaseReplicaResourcePropertiesArgs
                    {
                        DatabaseName = "db2",
                    },
                },
            },
            Info = new AzureNative.AzureArcData.Inputs.AvailabilityGroupInfoArgs
            {
                BasicFeatures = false,
                DbFailover = true,
                DtcSupport = false,
                FailureConditionLevel = 3,
                HealthCheckTimeout = 30000,
                IsContained = false,
                IsDistributed = false,
                RequiredSynchronizedSecondariesToCommit = 0,
            },
            Replicas = new AzureNative.AzureArcData.Inputs.SqlServerAvailabilityGroupResourcePropertiesReplicasArgs
            {
                Value = new[]
                {
                    new AzureNative.AzureArcData.Inputs.SqlAvailabilityGroupReplicaResourcePropertiesArgs
                    {
                        Configure = new AzureNative.AzureArcData.Inputs.AvailabilityGroupConfigureArgs
                        {
                            BackupPriority = 50,
                            EndpointUrl = "TCP://mytest60-0.mytest60-svc:5022",
                            SessionTimeout = 10,
                        },
                        ReplicaName = "testSqlServer\\INST1",
                    },
                },
            },
        },
        ResourceGroupName = "testrg",
        SqlServerInstanceName = "testSqlServer_INST1",
        Tags =
        {
            { "mytag", "myval" },
        },
    });
});

package main
import (
	azurearcdata "github.com/pulumi/pulumi-azure-native-sdk/azurearcdata/v2"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := azurearcdata.NewSqlServerAvailabilityGroup(ctx, "sqlServerAvailabilityGroup", &azurearcdata.SqlServerAvailabilityGroupArgs{
			AvailabilityGroupName: pulumi.String("testAG"),
			Location:              pulumi.String("southeastasia"),
			Properties: &azurearcdata.SqlServerAvailabilityGroupResourcePropertiesArgs{
				Databases: &azurearcdata.SqlServerAvailabilityGroupResourcePropertiesDatabasesArgs{
					Value: azurearcdata.SqlAvailabilityGroupDatabaseReplicaResourcePropertiesArray{
						&azurearcdata.SqlAvailabilityGroupDatabaseReplicaResourcePropertiesArgs{
							DatabaseName: pulumi.String("db1"),
						},
						&azurearcdata.SqlAvailabilityGroupDatabaseReplicaResourcePropertiesArgs{
							DatabaseName: pulumi.String("db2"),
						},
					},
				},
				Info: &azurearcdata.AvailabilityGroupInfoArgs{
					BasicFeatures:                           pulumi.Bool(false),
					DbFailover:                              pulumi.Bool(true),
					DtcSupport:                              pulumi.Bool(false),
					FailureConditionLevel:                   pulumi.Int(3),
					HealthCheckTimeout:                      pulumi.Int(30000),
					IsContained:                             pulumi.Bool(false),
					IsDistributed:                           pulumi.Bool(false),
					RequiredSynchronizedSecondariesToCommit: pulumi.Int(0),
				},
				Replicas: &azurearcdata.SqlServerAvailabilityGroupResourcePropertiesReplicasArgs{
					Value: azurearcdata.SqlAvailabilityGroupReplicaResourcePropertiesArray{
						&azurearcdata.SqlAvailabilityGroupReplicaResourcePropertiesArgs{
							Configure: &azurearcdata.AvailabilityGroupConfigureArgs{
								BackupPriority: pulumi.Int(50),
								EndpointUrl:    pulumi.String("TCP://mytest60-0.mytest60-svc:5022"),
								SessionTimeout: pulumi.Int(10),
							},
							ReplicaName: pulumi.String("testSqlServer\\INST1"),
						},
					},
				},
			},
			ResourceGroupName:     pulumi.String("testrg"),
			SqlServerInstanceName: pulumi.String("testSqlServer_INST1"),
			Tags: pulumi.StringMap{
				"mytag": pulumi.String("myval"),
			},
		})
		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.azurenative.azurearcdata.SqlServerAvailabilityGroup;
import com.pulumi.azurenative.azurearcdata.SqlServerAvailabilityGroupArgs;
import com.pulumi.azurenative.azurearcdata.inputs.SqlServerAvailabilityGroupResourcePropertiesArgs;
import com.pulumi.azurenative.azurearcdata.inputs.SqlServerAvailabilityGroupResourcePropertiesDatabasesArgs;
import com.pulumi.azurenative.azurearcdata.inputs.AvailabilityGroupInfoArgs;
import com.pulumi.azurenative.azurearcdata.inputs.SqlServerAvailabilityGroupResourcePropertiesReplicasArgs;
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 sqlServerAvailabilityGroup = new SqlServerAvailabilityGroup("sqlServerAvailabilityGroup", SqlServerAvailabilityGroupArgs.builder()
            .availabilityGroupName("testAG")
            .location("southeastasia")
            .properties(SqlServerAvailabilityGroupResourcePropertiesArgs.builder()
                .databases(SqlServerAvailabilityGroupResourcePropertiesDatabasesArgs.builder()
                    .value(
                        SqlAvailabilityGroupDatabaseReplicaResourcePropertiesArgs.builder()
                            .databaseName("db1")
                            .build(),
                        SqlAvailabilityGroupDatabaseReplicaResourcePropertiesArgs.builder()
                            .databaseName("db2")
                            .build())
                    .build())
                .info(AvailabilityGroupInfoArgs.builder()
                    .basicFeatures(false)
                    .dbFailover(true)
                    .dtcSupport(false)
                    .failureConditionLevel(3)
                    .healthCheckTimeout(30000)
                    .isContained(false)
                    .isDistributed(false)
                    .requiredSynchronizedSecondariesToCommit(0)
                    .build())
                .replicas(SqlServerAvailabilityGroupResourcePropertiesReplicasArgs.builder()
                    .value(SqlAvailabilityGroupReplicaResourcePropertiesArgs.builder()
                        .configure(AvailabilityGroupConfigureArgs.builder()
                            .backupPriority(50)
                            .endpointUrl("TCP://mytest60-0.mytest60-svc:5022")
                            .sessionTimeout(10)
                            .build())
                        .replicaName("testSqlServer\\INST1")
                        .build())
                    .build())
                .build())
            .resourceGroupName("testrg")
            .sqlServerInstanceName("testSqlServer_INST1")
            .tags(Map.of("mytag", "myval"))
            .build());
    }
}

Import

An existing resource can be imported using its type token, name, and identifier, e.g.

$ pulumi import azure-native:azurearcdata:SqlServerAvailabilityGroup testAG /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.AzureArcData/sqlServerInstances/{sqlServerInstanceName}/availabilityGroups/{availabilityGroupName}