Azure Native v2.20.0, Nov 29 23

This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.

Azure Native v2.20.0 published on Wednesday, Nov 29, 2023 by Pulumi

pulumi/pulumi-azure-native

azure-native.sqlvirtualmachine.SqlVirtualMachine

Explore with Pulumi AI

This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.

Azure Native v2.20.0 published on Wednesday, Nov 29, 2023 by Pulumi

pulumi/pulumi-azure-native

Example Usage

Creates or updates a SQL virtual machine and joins it to a SQL virtual machine group.

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;

return await Deployment.RunAsync(() => 
{
    var sqlVirtualMachine = new AzureNative.SqlVirtualMachine.SqlVirtualMachine("sqlVirtualMachine", new()
    {
        Location = "northeurope",
        ResourceGroupName = "testrg",
        SqlVirtualMachineGroupResourceId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachineGroups/testvmgroup",
        SqlVirtualMachineName = "testvm",
        VirtualMachineResourceId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm2",
        WsfcDomainCredentials = new AzureNative.SqlVirtualMachine.Inputs.WsfcDomainCredentialsArgs
        {
            ClusterBootstrapAccountPassword = "<Password>",
            ClusterOperatorAccountPassword = "<Password>",
            SqlServiceAccountPassword = "<Password>",
        },
        WsfcStaticIp = "10.0.0.7",
    });

});

package main

import (
	"github.com/pulumi/pulumi-azure-native-sdk/sqlvirtualmachine/v2"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sqlvirtualmachine.NewSqlVirtualMachine(ctx, "sqlVirtualMachine", &sqlvirtualmachine.SqlVirtualMachineArgs{
			Location:                         pulumi.String("northeurope"),
			ResourceGroupName:                pulumi.String("testrg"),
			SqlVirtualMachineGroupResourceId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachineGroups/testvmgroup"),
			SqlVirtualMachineName:            pulumi.String("testvm"),
			VirtualMachineResourceId:         pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm2"),
			WsfcDomainCredentials: &sqlvirtualmachine.WsfcDomainCredentialsArgs{
				ClusterBootstrapAccountPassword: pulumi.String("<Password>"),
				ClusterOperatorAccountPassword:  pulumi.String("<Password>"),
				SqlServiceAccountPassword:       pulumi.String("<Password>"),
			},
			WsfcStaticIp: pulumi.String("10.0.0.7"),
		})
		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.sqlvirtualmachine.SqlVirtualMachine;
import com.pulumi.azurenative.sqlvirtualmachine.SqlVirtualMachineArgs;
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 sqlVirtualMachine = new SqlVirtualMachine("sqlVirtualMachine", SqlVirtualMachineArgs.builder()        
            .location("northeurope")
            .resourceGroupName("testrg")
            .sqlVirtualMachineGroupResourceId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachineGroups/testvmgroup")
            .sqlVirtualMachineName("testvm")
            .virtualMachineResourceId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm2")
            .wsfcDomainCredentials(Map.ofEntries(
                Map.entry("clusterBootstrapAccountPassword", "<Password>"),
                Map.entry("clusterOperatorAccountPassword", "<Password>"),
                Map.entry("sqlServiceAccountPassword", "<Password>")
            ))
            .wsfcStaticIp("10.0.0.7")
            .build());

    }
}

import pulumi
import pulumi_azure_native as azure_native

sql_virtual_machine = azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine",
    location="northeurope",
    resource_group_name="testrg",
    sql_virtual_machine_group_resource_id="/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachineGroups/testvmgroup",
    sql_virtual_machine_name="testvm",
    virtual_machine_resource_id="/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm2",
    wsfc_domain_credentials=azure_native.sqlvirtualmachine.WsfcDomainCredentialsArgs(
        cluster_bootstrap_account_password="<Password>",
        cluster_operator_account_password="<Password>",
        sql_service_account_password="<Password>",
    ),
    wsfc_static_ip="10.0.0.7")

import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const sqlVirtualMachine = new azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine", {
    location: "northeurope",
    resourceGroupName: "testrg",
    sqlVirtualMachineGroupResourceId: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachineGroups/testvmgroup",
    sqlVirtualMachineName: "testvm",
    virtualMachineResourceId: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm2",
    wsfcDomainCredentials: {
        clusterBootstrapAccountPassword: "<Password>",
        clusterOperatorAccountPassword: "<Password>",
        sqlServiceAccountPassword: "<Password>",
    },
    wsfcStaticIp: "10.0.0.7",
});

resources:
  sqlVirtualMachine:
    type: azure-native:sqlvirtualmachine:SqlVirtualMachine
    properties:
      location: northeurope
      resourceGroupName: testrg
      sqlVirtualMachineGroupResourceId: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachineGroups/testvmgroup
      sqlVirtualMachineName: testvm
      virtualMachineResourceId: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm2
      wsfcDomainCredentials:
        clusterBootstrapAccountPassword: <Password>
        clusterOperatorAccountPassword: <Password>
        sqlServiceAccountPassword: <Password>
      wsfcStaticIp: 10.0.0.7

Creates or updates a SQL virtual machine for Automated Back up Settings with Weekly and Days of the week to run the back up.

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;

return await Deployment.RunAsync(() => 
{
    var sqlVirtualMachine = new AzureNative.SqlVirtualMachine.SqlVirtualMachine("sqlVirtualMachine", new()
    {
        AutoBackupSettings = new AzureNative.SqlVirtualMachine.Inputs.AutoBackupSettingsArgs
        {
            BackupScheduleType = "Manual",
            BackupSystemDbs = true,
            DaysOfWeek = new[]
            {
                "Monday",
                "Friday",
            },
            Enable = true,
            EnableEncryption = true,
            FullBackupFrequency = "Weekly",
            FullBackupStartTime = 6,
            FullBackupWindowHours = 11,
            LogBackupFrequency = 10,
            Password = "<Password>",
            RetentionPeriod = 17,
            StorageAccessKey = "<primary storage access key>",
            StorageAccountUrl = "https://teststorage.blob.core.windows.net/",
            StorageContainerName = "testcontainer",
        },
        AutoPatchingSettings = new AzureNative.SqlVirtualMachine.Inputs.AutoPatchingSettingsArgs
        {
            DayOfWeek = AzureNative.SqlVirtualMachine.DayOfWeek.Sunday,
            Enable = true,
            MaintenanceWindowDuration = 60,
            MaintenanceWindowStartingHour = 2,
        },
        KeyVaultCredentialSettings = new AzureNative.SqlVirtualMachine.Inputs.KeyVaultCredentialSettingsArgs
        {
            Enable = false,
        },
        Location = "northeurope",
        ResourceGroupName = "testrg",
        ServerConfigurationsManagementSettings = new AzureNative.SqlVirtualMachine.Inputs.ServerConfigurationsManagementSettingsArgs
        {
            AdditionalFeaturesServerConfigurations = new AzureNative.SqlVirtualMachine.Inputs.AdditionalFeaturesServerConfigurationsArgs
            {
                IsRServicesEnabled = false,
            },
            SqlConnectivityUpdateSettings = new AzureNative.SqlVirtualMachine.Inputs.SqlConnectivityUpdateSettingsArgs
            {
                ConnectivityType = "PRIVATE",
                Port = 1433,
                SqlAuthUpdatePassword = "<password>",
                SqlAuthUpdateUserName = "sqllogin",
            },
            SqlStorageUpdateSettings = new AzureNative.SqlVirtualMachine.Inputs.SqlStorageUpdateSettingsArgs
            {
                DiskConfigurationType = "NEW",
                DiskCount = 1,
                StartingDeviceId = 2,
            },
            SqlWorkloadTypeUpdateSettings = new AzureNative.SqlVirtualMachine.Inputs.SqlWorkloadTypeUpdateSettingsArgs
            {
                SqlWorkloadType = "OLTP",
            },
        },
        SqlImageSku = "Enterprise",
        SqlManagement = "Full",
        SqlServerLicenseType = "PAYG",
        SqlVirtualMachineName = "testvm",
        VirtualMachineResourceId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm",
    });

});

package main

import (
	"github.com/pulumi/pulumi-azure-native-sdk/sqlvirtualmachine/v2"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sqlvirtualmachine.NewSqlVirtualMachine(ctx, "sqlVirtualMachine", &sqlvirtualmachine.SqlVirtualMachineArgs{
			AutoBackupSettings: &sqlvirtualmachine.AutoBackupSettingsArgs{
				BackupScheduleType: pulumi.String("Manual"),
				BackupSystemDbs:    pulumi.Bool(true),
				DaysOfWeek: pulumi.StringArray{
					pulumi.String("Monday"),
					pulumi.String("Friday"),
				},
				Enable:                pulumi.Bool(true),
				EnableEncryption:      pulumi.Bool(true),
				FullBackupFrequency:   pulumi.String("Weekly"),
				FullBackupStartTime:   pulumi.Int(6),
				FullBackupWindowHours: pulumi.Int(11),
				LogBackupFrequency:    pulumi.Int(10),
				Password:              pulumi.String("<Password>"),
				RetentionPeriod:       pulumi.Int(17),
				StorageAccessKey:      pulumi.String("<primary storage access key>"),
				StorageAccountUrl:     pulumi.String("https://teststorage.blob.core.windows.net/"),
				StorageContainerName:  pulumi.String("testcontainer"),
			},
			AutoPatchingSettings: &sqlvirtualmachine.AutoPatchingSettingsArgs{
				DayOfWeek:                     sqlvirtualmachine.DayOfWeekSunday,
				Enable:                        pulumi.Bool(true),
				MaintenanceWindowDuration:     pulumi.Int(60),
				MaintenanceWindowStartingHour: pulumi.Int(2),
			},
			KeyVaultCredentialSettings: &sqlvirtualmachine.KeyVaultCredentialSettingsArgs{
				Enable: pulumi.Bool(false),
			},
			Location:          pulumi.String("northeurope"),
			ResourceGroupName: pulumi.String("testrg"),
			ServerConfigurationsManagementSettings: sqlvirtualmachine.ServerConfigurationsManagementSettingsResponse{
				AdditionalFeaturesServerConfigurations: &sqlvirtualmachine.AdditionalFeaturesServerConfigurationsArgs{
					IsRServicesEnabled: pulumi.Bool(false),
				},
				SqlConnectivityUpdateSettings: &sqlvirtualmachine.SqlConnectivityUpdateSettingsArgs{
					ConnectivityType:      pulumi.String("PRIVATE"),
					Port:                  pulumi.Int(1433),
					SqlAuthUpdatePassword: pulumi.String("<password>"),
					SqlAuthUpdateUserName: pulumi.String("sqllogin"),
				},
				SqlStorageUpdateSettings: &sqlvirtualmachine.SqlStorageUpdateSettingsArgs{
					DiskConfigurationType: pulumi.String("NEW"),
					DiskCount:             pulumi.Int(1),
					StartingDeviceId:      pulumi.Int(2),
				},
				SqlWorkloadTypeUpdateSettings: &sqlvirtualmachine.SqlWorkloadTypeUpdateSettingsArgs{
					SqlWorkloadType: pulumi.String("OLTP"),
				},
			},
			SqlImageSku:              pulumi.String("Enterprise"),
			SqlManagement:            pulumi.String("Full"),
			SqlServerLicenseType:     pulumi.String("PAYG"),
			SqlVirtualMachineName:    pulumi.String("testvm"),
			VirtualMachineResourceId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm"),
		})
		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.sqlvirtualmachine.SqlVirtualMachine;
import com.pulumi.azurenative.sqlvirtualmachine.SqlVirtualMachineArgs;
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 sqlVirtualMachine = new SqlVirtualMachine("sqlVirtualMachine", SqlVirtualMachineArgs.builder()        
            .autoBackupSettings(Map.ofEntries(
                Map.entry("backupScheduleType", "Manual"),
                Map.entry("backupSystemDbs", true),
                Map.entry("daysOfWeek",                 
                    "Monday",
                    "Friday"),
                Map.entry("enable", true),
                Map.entry("enableEncryption", true),
                Map.entry("fullBackupFrequency", "Weekly"),
                Map.entry("fullBackupStartTime", 6),
                Map.entry("fullBackupWindowHours", 11),
                Map.entry("logBackupFrequency", 10),
                Map.entry("password", "<Password>"),
                Map.entry("retentionPeriod", 17),
                Map.entry("storageAccessKey", "<primary storage access key>"),
                Map.entry("storageAccountUrl", "https://teststorage.blob.core.windows.net/"),
                Map.entry("storageContainerName", "testcontainer")
            ))
            .autoPatchingSettings(Map.ofEntries(
                Map.entry("dayOfWeek", "Sunday"),
                Map.entry("enable", true),
                Map.entry("maintenanceWindowDuration", 60),
                Map.entry("maintenanceWindowStartingHour", 2)
            ))
            .keyVaultCredentialSettings(Map.of("enable", false))
            .location("northeurope")
            .resourceGroupName("testrg")
            .serverConfigurationsManagementSettings(Map.ofEntries(
                Map.entry("additionalFeaturesServerConfigurations", Map.of("isRServicesEnabled", false)),
                Map.entry("sqlConnectivityUpdateSettings", Map.ofEntries(
                    Map.entry("connectivityType", "PRIVATE"),
                    Map.entry("port", 1433),
                    Map.entry("sqlAuthUpdatePassword", "<password>"),
                    Map.entry("sqlAuthUpdateUserName", "sqllogin")
                )),
                Map.entry("sqlStorageUpdateSettings", Map.ofEntries(
                    Map.entry("diskConfigurationType", "NEW"),
                    Map.entry("diskCount", 1),
                    Map.entry("startingDeviceId", 2)
                )),
                Map.entry("sqlWorkloadTypeUpdateSettings", Map.of("sqlWorkloadType", "OLTP"))
            ))
            .sqlImageSku("Enterprise")
            .sqlManagement("Full")
            .sqlServerLicenseType("PAYG")
            .sqlVirtualMachineName("testvm")
            .virtualMachineResourceId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm")
            .build());

    }
}

import pulumi
import pulumi_azure_native as azure_native

sql_virtual_machine = azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine",
    auto_backup_settings=azure_native.sqlvirtualmachine.AutoBackupSettingsArgs(
        backup_schedule_type="Manual",
        backup_system_dbs=True,
        days_of_week=[
            "Monday",
            "Friday",
        ],
        enable=True,
        enable_encryption=True,
        full_backup_frequency="Weekly",
        full_backup_start_time=6,
        full_backup_window_hours=11,
        log_backup_frequency=10,
        password="<Password>",
        retention_period=17,
        storage_access_key="<primary storage access key>",
        storage_account_url="https://teststorage.blob.core.windows.net/",
        storage_container_name="testcontainer",
    ),
    auto_patching_settings=azure_native.sqlvirtualmachine.AutoPatchingSettingsArgs(
        day_of_week=azure_native.sqlvirtualmachine.DayOfWeek.SUNDAY,
        enable=True,
        maintenance_window_duration=60,
        maintenance_window_starting_hour=2,
    ),
    key_vault_credential_settings=azure_native.sqlvirtualmachine.KeyVaultCredentialSettingsArgs(
        enable=False,
    ),
    location="northeurope",
    resource_group_name="testrg",
    server_configurations_management_settings=azure_native.sqlvirtualmachine.ServerConfigurationsManagementSettingsResponseArgs(
        additional_features_server_configurations=azure_native.sqlvirtualmachine.AdditionalFeaturesServerConfigurationsArgs(
            is_r_services_enabled=False,
        ),
        sql_connectivity_update_settings=azure_native.sqlvirtualmachine.SqlConnectivityUpdateSettingsArgs(
            connectivity_type="PRIVATE",
            port=1433,
            sql_auth_update_password="<password>",
            sql_auth_update_user_name="sqllogin",
        ),
        sql_storage_update_settings=azure_native.sqlvirtualmachine.SqlStorageUpdateSettingsArgs(
            disk_configuration_type="NEW",
            disk_count=1,
            starting_device_id=2,
        ),
        sql_workload_type_update_settings=azure_native.sqlvirtualmachine.SqlWorkloadTypeUpdateSettingsArgs(
            sql_workload_type="OLTP",
        ),
    ),
    sql_image_sku="Enterprise",
    sql_management="Full",
    sql_server_license_type="PAYG",
    sql_virtual_machine_name="testvm",
    virtual_machine_resource_id="/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm")

import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const sqlVirtualMachine = new azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine", {
    autoBackupSettings: {
        backupScheduleType: "Manual",
        backupSystemDbs: true,
        daysOfWeek: [
            "Monday",
            "Friday",
        ],
        enable: true,
        enableEncryption: true,
        fullBackupFrequency: "Weekly",
        fullBackupStartTime: 6,
        fullBackupWindowHours: 11,
        logBackupFrequency: 10,
        password: "<Password>",
        retentionPeriod: 17,
        storageAccessKey: "<primary storage access key>",
        storageAccountUrl: "https://teststorage.blob.core.windows.net/",
        storageContainerName: "testcontainer",
    },
    autoPatchingSettings: {
        dayOfWeek: azure_native.sqlvirtualmachine.DayOfWeek.Sunday,
        enable: true,
        maintenanceWindowDuration: 60,
        maintenanceWindowStartingHour: 2,
    },
    keyVaultCredentialSettings: {
        enable: false,
    },
    location: "northeurope",
    resourceGroupName: "testrg",
    serverConfigurationsManagementSettings: {
        additionalFeaturesServerConfigurations: {
            isRServicesEnabled: false,
        },
        sqlConnectivityUpdateSettings: {
            connectivityType: "PRIVATE",
            port: 1433,
            sqlAuthUpdatePassword: "<password>",
            sqlAuthUpdateUserName: "sqllogin",
        },
        sqlStorageUpdateSettings: {
            diskConfigurationType: "NEW",
            diskCount: 1,
            startingDeviceId: 2,
        },
        sqlWorkloadTypeUpdateSettings: {
            sqlWorkloadType: "OLTP",
        },
    },
    sqlImageSku: "Enterprise",
    sqlManagement: "Full",
    sqlServerLicenseType: "PAYG",
    sqlVirtualMachineName: "testvm",
    virtualMachineResourceId: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm",
});

resources:
  sqlVirtualMachine:
    type: azure-native:sqlvirtualmachine:SqlVirtualMachine
    properties:
      autoBackupSettings:
        backupScheduleType: Manual
        backupSystemDbs: true
        daysOfWeek:
          - Monday
          - Friday
        enable: true
        enableEncryption: true
        fullBackupFrequency: Weekly
        fullBackupStartTime: 6
        fullBackupWindowHours: 11
        logBackupFrequency: 10
        password: <Password>
        retentionPeriod: 17
        storageAccessKey: <primary storage access key>
        storageAccountUrl: https://teststorage.blob.core.windows.net/
        storageContainerName: testcontainer
      autoPatchingSettings:
        dayOfWeek: Sunday
        enable: true
        maintenanceWindowDuration: 60
        maintenanceWindowStartingHour: 2
      keyVaultCredentialSettings:
        enable: false
      location: northeurope
      resourceGroupName: testrg
      serverConfigurationsManagementSettings:
        additionalFeaturesServerConfigurations:
          isRServicesEnabled: false
        sqlConnectivityUpdateSettings:
          connectivityType: PRIVATE
          port: 1433
          sqlAuthUpdatePassword: <password>
          sqlAuthUpdateUserName: sqllogin
        sqlStorageUpdateSettings:
          diskConfigurationType: NEW
          diskCount: 1
          startingDeviceId: 2
        sqlWorkloadTypeUpdateSettings:
          sqlWorkloadType: OLTP
      sqlImageSku: Enterprise
      sqlManagement: Full
      sqlServerLicenseType: PAYG
      sqlVirtualMachineName: testvm
      virtualMachineResourceId: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm

Creates or updates a SQL virtual machine for Storage Configuration Settings to EXTEND Data, Log or TempDB storage pool.

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;

return await Deployment.RunAsync(() => 
{
    var sqlVirtualMachine = new AzureNative.SqlVirtualMachine.SqlVirtualMachine("sqlVirtualMachine", new()
    {
        Location = "northeurope",
        ResourceGroupName = "testrg",
        SqlVirtualMachineName = "testvm",
        StorageConfigurationSettings = new AzureNative.SqlVirtualMachine.Inputs.StorageConfigurationSettingsArgs
        {
            DiskConfigurationType = "EXTEND",
            SqlDataSettings = new AzureNative.SqlVirtualMachine.Inputs.SQLStorageSettingsArgs
            {
                Luns = new[]
                {
                    2,
                },
            },
        },
        VirtualMachineResourceId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm",
    });

});

package main

import (
	"github.com/pulumi/pulumi-azure-native-sdk/sqlvirtualmachine/v2"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sqlvirtualmachine.NewSqlVirtualMachine(ctx, "sqlVirtualMachine", &sqlvirtualmachine.SqlVirtualMachineArgs{
			Location:              pulumi.String("northeurope"),
			ResourceGroupName:     pulumi.String("testrg"),
			SqlVirtualMachineName: pulumi.String("testvm"),
			StorageConfigurationSettings: sqlvirtualmachine.StorageConfigurationSettingsResponse{
				DiskConfigurationType: pulumi.String("EXTEND"),
				SqlDataSettings: &sqlvirtualmachine.SQLStorageSettingsArgs{
					Luns: pulumi.IntArray{
						pulumi.Int(2),
					},
				},
			},
			VirtualMachineResourceId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm"),
		})
		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.sqlvirtualmachine.SqlVirtualMachine;
import com.pulumi.azurenative.sqlvirtualmachine.SqlVirtualMachineArgs;
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 sqlVirtualMachine = new SqlVirtualMachine("sqlVirtualMachine", SqlVirtualMachineArgs.builder()        
            .location("northeurope")
            .resourceGroupName("testrg")
            .sqlVirtualMachineName("testvm")
            .storageConfigurationSettings(Map.ofEntries(
                Map.entry("diskConfigurationType", "EXTEND"),
                Map.entry("sqlDataSettings", Map.of("luns", 2))
            ))
            .virtualMachineResourceId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm")
            .build());

    }
}

import pulumi
import pulumi_azure_native as azure_native

sql_virtual_machine = azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine",
    location="northeurope",
    resource_group_name="testrg",
    sql_virtual_machine_name="testvm",
    storage_configuration_settings=azure_native.sqlvirtualmachine.StorageConfigurationSettingsResponseArgs(
        disk_configuration_type="EXTEND",
        sql_data_settings=azure_native.sqlvirtualmachine.SQLStorageSettingsArgs(
            luns=[2],
        ),
    ),
    virtual_machine_resource_id="/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm")

import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const sqlVirtualMachine = new azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine", {
    location: "northeurope",
    resourceGroupName: "testrg",
    sqlVirtualMachineName: "testvm",
    storageConfigurationSettings: {
        diskConfigurationType: "EXTEND",
        sqlDataSettings: {
            luns: [2],
        },
    },
    virtualMachineResourceId: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm",
});

resources:
  sqlVirtualMachine:
    type: azure-native:sqlvirtualmachine:SqlVirtualMachine
    properties:
      location: northeurope
      resourceGroupName: testrg
      sqlVirtualMachineName: testvm
      storageConfigurationSettings:
        diskConfigurationType: EXTEND
        sqlDataSettings:
          luns:
            - 2
      virtualMachineResourceId: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm

Creates or updates a SQL virtual machine for Storage Configuration Settings to NEW Data, Log and TempDB storage pool.

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;

return await Deployment.RunAsync(() => 
{
    var sqlVirtualMachine = new AzureNative.SqlVirtualMachine.SqlVirtualMachine("sqlVirtualMachine", new()
    {
        Location = "northeurope",
        ResourceGroupName = "testrg",
        SqlVirtualMachineName = "testvm",
        StorageConfigurationSettings = new AzureNative.SqlVirtualMachine.Inputs.StorageConfigurationSettingsArgs
        {
            DiskConfigurationType = "NEW",
            SqlDataSettings = new AzureNative.SqlVirtualMachine.Inputs.SQLStorageSettingsArgs
            {
                DefaultFilePath = "F:\\folderpath\\",
                Luns = new[]
                {
                    0,
                },
            },
            SqlLogSettings = new AzureNative.SqlVirtualMachine.Inputs.SQLStorageSettingsArgs
            {
                DefaultFilePath = "G:\\folderpath\\",
                Luns = new[]
                {
                    1,
                },
            },
            SqlSystemDbOnDataDisk = true,
            SqlTempDbSettings = new AzureNative.SqlVirtualMachine.Inputs.SQLTempDbSettingsArgs
            {
                DataFileCount = 8,
                DataFileSize = 256,
                DataGrowth = 512,
                DefaultFilePath = "D:\\TEMP",
                LogFileSize = 256,
                LogGrowth = 512,
            },
            StorageWorkloadType = "OLTP",
        },
        VirtualMachineResourceId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm",
    });

});

package main

import (
	"github.com/pulumi/pulumi-azure-native-sdk/sqlvirtualmachine/v2"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sqlvirtualmachine.NewSqlVirtualMachine(ctx, "sqlVirtualMachine", &sqlvirtualmachine.SqlVirtualMachineArgs{
			Location:              pulumi.String("northeurope"),
			ResourceGroupName:     pulumi.String("testrg"),
			SqlVirtualMachineName: pulumi.String("testvm"),
			StorageConfigurationSettings: sqlvirtualmachine.StorageConfigurationSettingsResponse{
				DiskConfigurationType: pulumi.String("NEW"),
				SqlDataSettings: &sqlvirtualmachine.SQLStorageSettingsArgs{
					DefaultFilePath: pulumi.String("F:\\folderpath\\"),
					Luns: pulumi.IntArray{
						pulumi.Int(0),
					},
				},
				SqlLogSettings: &sqlvirtualmachine.SQLStorageSettingsArgs{
					DefaultFilePath: pulumi.String("G:\\folderpath\\"),
					Luns: pulumi.IntArray{
						pulumi.Int(1),
					},
				},
				SqlSystemDbOnDataDisk: pulumi.Bool(true),
				SqlTempDbSettings: &sqlvirtualmachine.SQLTempDbSettingsArgs{
					DataFileCount:   pulumi.Int(8),
					DataFileSize:    pulumi.Int(256),
					DataGrowth:      pulumi.Int(512),
					DefaultFilePath: pulumi.String("D:\\TEMP"),
					LogFileSize:     pulumi.Int(256),
					LogGrowth:       pulumi.Int(512),
				},
				StorageWorkloadType: pulumi.String("OLTP"),
			},
			VirtualMachineResourceId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm"),
		})
		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.sqlvirtualmachine.SqlVirtualMachine;
import com.pulumi.azurenative.sqlvirtualmachine.SqlVirtualMachineArgs;
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 sqlVirtualMachine = new SqlVirtualMachine("sqlVirtualMachine", SqlVirtualMachineArgs.builder()        
            .location("northeurope")
            .resourceGroupName("testrg")
            .sqlVirtualMachineName("testvm")
            .storageConfigurationSettings(Map.ofEntries(
                Map.entry("diskConfigurationType", "NEW"),
                Map.entry("sqlDataSettings", Map.ofEntries(
                    Map.entry("defaultFilePath", "F:\\folderpath\\"),
                    Map.entry("luns", 0)
                )),
                Map.entry("sqlLogSettings", Map.ofEntries(
                    Map.entry("defaultFilePath", "G:\\folderpath\\"),
                    Map.entry("luns", 1)
                )),
                Map.entry("sqlSystemDbOnDataDisk", true),
                Map.entry("sqlTempDbSettings", Map.ofEntries(
                    Map.entry("dataFileCount", 8),
                    Map.entry("dataFileSize", 256),
                    Map.entry("dataGrowth", 512),
                    Map.entry("defaultFilePath", "D:\\TEMP"),
                    Map.entry("logFileSize", 256),
                    Map.entry("logGrowth", 512)
                )),
                Map.entry("storageWorkloadType", "OLTP")
            ))
            .virtualMachineResourceId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm")
            .build());

    }
}

import pulumi
import pulumi_azure_native as azure_native

sql_virtual_machine = azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine",
    location="northeurope",
    resource_group_name="testrg",
    sql_virtual_machine_name="testvm",
    storage_configuration_settings=azure_native.sqlvirtualmachine.StorageConfigurationSettingsResponseArgs(
        disk_configuration_type="NEW",
        sql_data_settings=azure_native.sqlvirtualmachine.SQLStorageSettingsArgs(
            default_file_path="F:\\folderpath\\",
            luns=[0],
        ),
        sql_log_settings=azure_native.sqlvirtualmachine.SQLStorageSettingsArgs(
            default_file_path="G:\\folderpath\\",
            luns=[1],
        ),
        sql_system_db_on_data_disk=True,
        sql_temp_db_settings=azure_native.sqlvirtualmachine.SQLTempDbSettingsArgs(
            data_file_count=8,
            data_file_size=256,
            data_growth=512,
            default_file_path="D:\\TEMP",
            log_file_size=256,
            log_growth=512,
        ),
        storage_workload_type="OLTP",
    ),
    virtual_machine_resource_id="/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm")

import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const sqlVirtualMachine = new azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine", {
    location: "northeurope",
    resourceGroupName: "testrg",
    sqlVirtualMachineName: "testvm",
    storageConfigurationSettings: {
        diskConfigurationType: "NEW",
        sqlDataSettings: {
            defaultFilePath: "F:\\folderpath\\",
            luns: [0],
        },
        sqlLogSettings: {
            defaultFilePath: "G:\\folderpath\\",
            luns: [1],
        },
        sqlSystemDbOnDataDisk: true,
        sqlTempDbSettings: {
            dataFileCount: 8,
            dataFileSize: 256,
            dataGrowth: 512,
            defaultFilePath: "D:\\TEMP",
            logFileSize: 256,
            logGrowth: 512,
        },
        storageWorkloadType: "OLTP",
    },
    virtualMachineResourceId: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm",
});

resources:
  sqlVirtualMachine:
    type: azure-native:sqlvirtualmachine:SqlVirtualMachine
    properties:
      location: northeurope
      resourceGroupName: testrg
      sqlVirtualMachineName: testvm
      storageConfigurationSettings:
        diskConfigurationType: NEW
        sqlDataSettings:
          defaultFilePath: F:\folderpath\
          luns:
            - 0
        sqlLogSettings:
          defaultFilePath: G:\folderpath\
          luns:
            - 1
        sqlSystemDbOnDataDisk: true
        sqlTempDbSettings:
          dataFileCount: 8
          dataFileSize: 256
          dataGrowth: 512
          defaultFilePath: D:\TEMP
          logFileSize: 256
          logGrowth: 512
        storageWorkloadType: OLTP
      virtualMachineResourceId: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm

Creates or updates a SQL virtual machine with max parameters.

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;

return await Deployment.RunAsync(() => 
{
    var sqlVirtualMachine = new AzureNative.SqlVirtualMachine.SqlVirtualMachine("sqlVirtualMachine", new()
    {
        AssessmentSettings = new AzureNative.SqlVirtualMachine.Inputs.AssessmentSettingsArgs
        {
            Enable = true,
            RunImmediately = true,
            Schedule = new AzureNative.SqlVirtualMachine.Inputs.ScheduleArgs
            {
                DayOfWeek = AzureNative.SqlVirtualMachine.AssessmentDayOfWeek.Sunday,
                Enable = true,
                StartTime = "23:17",
                WeeklyInterval = 1,
            },
        },
        AutoBackupSettings = new AzureNative.SqlVirtualMachine.Inputs.AutoBackupSettingsArgs
        {
            BackupScheduleType = "Manual",
            BackupSystemDbs = true,
            Enable = true,
            EnableEncryption = true,
            FullBackupFrequency = "Daily",
            FullBackupStartTime = 6,
            FullBackupWindowHours = 11,
            LogBackupFrequency = 10,
            Password = "<Password>",
            RetentionPeriod = 17,
            StorageAccessKey = "<primary storage access key>",
            StorageAccountUrl = "https://teststorage.blob.core.windows.net/",
            StorageContainerName = "testcontainer",
        },
        AutoPatchingSettings = new AzureNative.SqlVirtualMachine.Inputs.AutoPatchingSettingsArgs
        {
            DayOfWeek = AzureNative.SqlVirtualMachine.DayOfWeek.Sunday,
            Enable = true,
            MaintenanceWindowDuration = 60,
            MaintenanceWindowStartingHour = 2,
        },
        KeyVaultCredentialSettings = new AzureNative.SqlVirtualMachine.Inputs.KeyVaultCredentialSettingsArgs
        {
            Enable = false,
        },
        Location = "northeurope",
        ResourceGroupName = "testrg",
        ServerConfigurationsManagementSettings = new AzureNative.SqlVirtualMachine.Inputs.ServerConfigurationsManagementSettingsArgs
        {
            AdditionalFeaturesServerConfigurations = new AzureNative.SqlVirtualMachine.Inputs.AdditionalFeaturesServerConfigurationsArgs
            {
                IsRServicesEnabled = false,
            },
            SqlConnectivityUpdateSettings = new AzureNative.SqlVirtualMachine.Inputs.SqlConnectivityUpdateSettingsArgs
            {
                ConnectivityType = "PRIVATE",
                Port = 1433,
                SqlAuthUpdatePassword = "<password>",
                SqlAuthUpdateUserName = "sqllogin",
            },
            SqlInstanceSettings = new AzureNative.SqlVirtualMachine.Inputs.SQLInstanceSettingsArgs
            {
                Collation = "SQL_Latin1_General_CP1_CI_AS",
                IsIfiEnabled = true,
                IsLpimEnabled = true,
                IsOptimizeForAdHocWorkloadsEnabled = true,
                MaxDop = 8,
                MaxServerMemoryMB = 128,
                MinServerMemoryMB = 0,
            },
            SqlStorageUpdateSettings = new AzureNative.SqlVirtualMachine.Inputs.SqlStorageUpdateSettingsArgs
            {
                DiskConfigurationType = "NEW",
                DiskCount = 1,
                StartingDeviceId = 2,
            },
            SqlWorkloadTypeUpdateSettings = new AzureNative.SqlVirtualMachine.Inputs.SqlWorkloadTypeUpdateSettingsArgs
            {
                SqlWorkloadType = "OLTP",
            },
        },
        SqlImageSku = "Enterprise",
        SqlManagement = "Full",
        SqlServerLicenseType = "PAYG",
        SqlVirtualMachineName = "testvm",
        VirtualMachineResourceId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm",
    });

});

package main

import (
	"github.com/pulumi/pulumi-azure-native-sdk/sqlvirtualmachine/v2"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sqlvirtualmachine.NewSqlVirtualMachine(ctx, "sqlVirtualMachine", &sqlvirtualmachine.SqlVirtualMachineArgs{
			AssessmentSettings: sqlvirtualmachine.AssessmentSettingsResponse{
				Enable:         pulumi.Bool(true),
				RunImmediately: pulumi.Bool(true),
				Schedule: &sqlvirtualmachine.ScheduleArgs{
					DayOfWeek:      sqlvirtualmachine.AssessmentDayOfWeekSunday,
					Enable:         pulumi.Bool(true),
					StartTime:      pulumi.String("23:17"),
					WeeklyInterval: pulumi.Int(1),
				},
			},
			AutoBackupSettings: &sqlvirtualmachine.AutoBackupSettingsArgs{
				BackupScheduleType:    pulumi.String("Manual"),
				BackupSystemDbs:       pulumi.Bool(true),
				Enable:                pulumi.Bool(true),
				EnableEncryption:      pulumi.Bool(true),
				FullBackupFrequency:   pulumi.String("Daily"),
				FullBackupStartTime:   pulumi.Int(6),
				FullBackupWindowHours: pulumi.Int(11),
				LogBackupFrequency:    pulumi.Int(10),
				Password:              pulumi.String("<Password>"),
				RetentionPeriod:       pulumi.Int(17),
				StorageAccessKey:      pulumi.String("<primary storage access key>"),
				StorageAccountUrl:     pulumi.String("https://teststorage.blob.core.windows.net/"),
				StorageContainerName:  pulumi.String("testcontainer"),
			},
			AutoPatchingSettings: &sqlvirtualmachine.AutoPatchingSettingsArgs{
				DayOfWeek:                     sqlvirtualmachine.DayOfWeekSunday,
				Enable:                        pulumi.Bool(true),
				MaintenanceWindowDuration:     pulumi.Int(60),
				MaintenanceWindowStartingHour: pulumi.Int(2),
			},
			KeyVaultCredentialSettings: &sqlvirtualmachine.KeyVaultCredentialSettingsArgs{
				Enable: pulumi.Bool(false),
			},
			Location:          pulumi.String("northeurope"),
			ResourceGroupName: pulumi.String("testrg"),
			ServerConfigurationsManagementSettings: sqlvirtualmachine.ServerConfigurationsManagementSettingsResponse{
				AdditionalFeaturesServerConfigurations: &sqlvirtualmachine.AdditionalFeaturesServerConfigurationsArgs{
					IsRServicesEnabled: pulumi.Bool(false),
				},
				SqlConnectivityUpdateSettings: &sqlvirtualmachine.SqlConnectivityUpdateSettingsArgs{
					ConnectivityType:      pulumi.String("PRIVATE"),
					Port:                  pulumi.Int(1433),
					SqlAuthUpdatePassword: pulumi.String("<password>"),
					SqlAuthUpdateUserName: pulumi.String("sqllogin"),
				},
				SqlInstanceSettings: &sqlvirtualmachine.SQLInstanceSettingsArgs{
					Collation:                          pulumi.String("SQL_Latin1_General_CP1_CI_AS"),
					IsIfiEnabled:                       pulumi.Bool(true),
					IsLpimEnabled:                      pulumi.Bool(true),
					IsOptimizeForAdHocWorkloadsEnabled: pulumi.Bool(true),
					MaxDop:                             pulumi.Int(8),
					MaxServerMemoryMB:                  pulumi.Int(128),
					MinServerMemoryMB:                  pulumi.Int(0),
				},
				SqlStorageUpdateSettings: &sqlvirtualmachine.SqlStorageUpdateSettingsArgs{
					DiskConfigurationType: pulumi.String("NEW"),
					DiskCount:             pulumi.Int(1),
					StartingDeviceId:      pulumi.Int(2),
				},
				SqlWorkloadTypeUpdateSettings: &sqlvirtualmachine.SqlWorkloadTypeUpdateSettingsArgs{
					SqlWorkloadType: pulumi.String("OLTP"),
				},
			},
			SqlImageSku:              pulumi.String("Enterprise"),
			SqlManagement:            pulumi.String("Full"),
			SqlServerLicenseType:     pulumi.String("PAYG"),
			SqlVirtualMachineName:    pulumi.String("testvm"),
			VirtualMachineResourceId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm"),
		})
		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.sqlvirtualmachine.SqlVirtualMachine;
import com.pulumi.azurenative.sqlvirtualmachine.SqlVirtualMachineArgs;
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 sqlVirtualMachine = new SqlVirtualMachine("sqlVirtualMachine", SqlVirtualMachineArgs.builder()        
            .assessmentSettings(Map.ofEntries(
                Map.entry("enable", true),
                Map.entry("runImmediately", true),
                Map.entry("schedule", Map.ofEntries(
                    Map.entry("dayOfWeek", "Sunday"),
                    Map.entry("enable", true),
                    Map.entry("startTime", "23:17"),
                    Map.entry("weeklyInterval", 1)
                ))
            ))
            .autoBackupSettings(Map.ofEntries(
                Map.entry("backupScheduleType", "Manual"),
                Map.entry("backupSystemDbs", true),
                Map.entry("enable", true),
                Map.entry("enableEncryption", true),
                Map.entry("fullBackupFrequency", "Daily"),
                Map.entry("fullBackupStartTime", 6),
                Map.entry("fullBackupWindowHours", 11),
                Map.entry("logBackupFrequency", 10),
                Map.entry("password", "<Password>"),
                Map.entry("retentionPeriod", 17),
                Map.entry("storageAccessKey", "<primary storage access key>"),
                Map.entry("storageAccountUrl", "https://teststorage.blob.core.windows.net/"),
                Map.entry("storageContainerName", "testcontainer")
            ))
            .autoPatchingSettings(Map.ofEntries(
                Map.entry("dayOfWeek", "Sunday"),
                Map.entry("enable", true),
                Map.entry("maintenanceWindowDuration", 60),
                Map.entry("maintenanceWindowStartingHour", 2)
            ))
            .keyVaultCredentialSettings(Map.of("enable", false))
            .location("northeurope")
            .resourceGroupName("testrg")
            .serverConfigurationsManagementSettings(Map.ofEntries(
                Map.entry("additionalFeaturesServerConfigurations", Map.of("isRServicesEnabled", false)),
                Map.entry("sqlConnectivityUpdateSettings", Map.ofEntries(
                    Map.entry("connectivityType", "PRIVATE"),
                    Map.entry("port", 1433),
                    Map.entry("sqlAuthUpdatePassword", "<password>"),
                    Map.entry("sqlAuthUpdateUserName", "sqllogin")
                )),
                Map.entry("sqlInstanceSettings", Map.ofEntries(
                    Map.entry("collation", "SQL_Latin1_General_CP1_CI_AS"),
                    Map.entry("isIfiEnabled", true),
                    Map.entry("isLpimEnabled", true),
                    Map.entry("isOptimizeForAdHocWorkloadsEnabled", true),
                    Map.entry("maxDop", 8),
                    Map.entry("maxServerMemoryMB", 128),
                    Map.entry("minServerMemoryMB", 0)
                )),
                Map.entry("sqlStorageUpdateSettings", Map.ofEntries(
                    Map.entry("diskConfigurationType", "NEW"),
                    Map.entry("diskCount", 1),
                    Map.entry("startingDeviceId", 2)
                )),
                Map.entry("sqlWorkloadTypeUpdateSettings", Map.of("sqlWorkloadType", "OLTP"))
            ))
            .sqlImageSku("Enterprise")
            .sqlManagement("Full")
            .sqlServerLicenseType("PAYG")
            .sqlVirtualMachineName("testvm")
            .virtualMachineResourceId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm")
            .build());

    }
}

import pulumi
import pulumi_azure_native as azure_native

sql_virtual_machine = azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine",
    assessment_settings=azure_native.sqlvirtualmachine.AssessmentSettingsResponseArgs(
        enable=True,
        run_immediately=True,
        schedule=azure_native.sqlvirtualmachine.ScheduleArgs(
            day_of_week=azure_native.sqlvirtualmachine.AssessmentDayOfWeek.SUNDAY,
            enable=True,
            start_time="23:17",
            weekly_interval=1,
        ),
    ),
    auto_backup_settings=azure_native.sqlvirtualmachine.AutoBackupSettingsArgs(
        backup_schedule_type="Manual",
        backup_system_dbs=True,
        enable=True,
        enable_encryption=True,
        full_backup_frequency="Daily",
        full_backup_start_time=6,
        full_backup_window_hours=11,
        log_backup_frequency=10,
        password="<Password>",
        retention_period=17,
        storage_access_key="<primary storage access key>",
        storage_account_url="https://teststorage.blob.core.windows.net/",
        storage_container_name="testcontainer",
    ),
    auto_patching_settings=azure_native.sqlvirtualmachine.AutoPatchingSettingsArgs(
        day_of_week=azure_native.sqlvirtualmachine.DayOfWeek.SUNDAY,
        enable=True,
        maintenance_window_duration=60,
        maintenance_window_starting_hour=2,
    ),
    key_vault_credential_settings=azure_native.sqlvirtualmachine.KeyVaultCredentialSettingsArgs(
        enable=False,
    ),
    location="northeurope",
    resource_group_name="testrg",
    server_configurations_management_settings=azure_native.sqlvirtualmachine.ServerConfigurationsManagementSettingsResponseArgs(
        additional_features_server_configurations=azure_native.sqlvirtualmachine.AdditionalFeaturesServerConfigurationsArgs(
            is_r_services_enabled=False,
        ),
        sql_connectivity_update_settings=azure_native.sqlvirtualmachine.SqlConnectivityUpdateSettingsArgs(
            connectivity_type="PRIVATE",
            port=1433,
            sql_auth_update_password="<password>",
            sql_auth_update_user_name="sqllogin",
        ),
        sql_instance_settings=azure_native.sqlvirtualmachine.SQLInstanceSettingsArgs(
            collation="SQL_Latin1_General_CP1_CI_AS",
            is_ifi_enabled=True,
            is_lpim_enabled=True,
            is_optimize_for_ad_hoc_workloads_enabled=True,
            max_dop=8,
            max_server_memory_mb=128,
            min_server_memory_mb=0,
        ),
        sql_storage_update_settings=azure_native.sqlvirtualmachine.SqlStorageUpdateSettingsArgs(
            disk_configuration_type="NEW",
            disk_count=1,
            starting_device_id=2,
        ),
        sql_workload_type_update_settings=azure_native.sqlvirtualmachine.SqlWorkloadTypeUpdateSettingsArgs(
            sql_workload_type="OLTP",
        ),
    ),
    sql_image_sku="Enterprise",
    sql_management="Full",
    sql_server_license_type="PAYG",
    sql_virtual_machine_name="testvm",
    virtual_machine_resource_id="/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm")

import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const sqlVirtualMachine = new azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine", {
    assessmentSettings: {
        enable: true,
        runImmediately: true,
        schedule: {
            dayOfWeek: azure_native.sqlvirtualmachine.AssessmentDayOfWeek.Sunday,
            enable: true,
            startTime: "23:17",
            weeklyInterval: 1,
        },
    },
    autoBackupSettings: {
        backupScheduleType: "Manual",
        backupSystemDbs: true,
        enable: true,
        enableEncryption: true,
        fullBackupFrequency: "Daily",
        fullBackupStartTime: 6,
        fullBackupWindowHours: 11,
        logBackupFrequency: 10,
        password: "<Password>",
        retentionPeriod: 17,
        storageAccessKey: "<primary storage access key>",
        storageAccountUrl: "https://teststorage.blob.core.windows.net/",
        storageContainerName: "testcontainer",
    },
    autoPatchingSettings: {
        dayOfWeek: azure_native.sqlvirtualmachine.DayOfWeek.Sunday,
        enable: true,
        maintenanceWindowDuration: 60,
        maintenanceWindowStartingHour: 2,
    },
    keyVaultCredentialSettings: {
        enable: false,
    },
    location: "northeurope",
    resourceGroupName: "testrg",
    serverConfigurationsManagementSettings: {
        additionalFeaturesServerConfigurations: {
            isRServicesEnabled: false,
        },
        sqlConnectivityUpdateSettings: {
            connectivityType: "PRIVATE",
            port: 1433,
            sqlAuthUpdatePassword: "<password>",
            sqlAuthUpdateUserName: "sqllogin",
        },
        sqlInstanceSettings: {
            collation: "SQL_Latin1_General_CP1_CI_AS",
            isIfiEnabled: true,
            isLpimEnabled: true,
            isOptimizeForAdHocWorkloadsEnabled: true,
            maxDop: 8,
            maxServerMemoryMB: 128,
            minServerMemoryMB: 0,
        },
        sqlStorageUpdateSettings: {
            diskConfigurationType: "NEW",
            diskCount: 1,
            startingDeviceId: 2,
        },
        sqlWorkloadTypeUpdateSettings: {
            sqlWorkloadType: "OLTP",
        },
    },
    sqlImageSku: "Enterprise",
    sqlManagement: "Full",
    sqlServerLicenseType: "PAYG",
    sqlVirtualMachineName: "testvm",
    virtualMachineResourceId: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm",
});

resources:
  sqlVirtualMachine:
    type: azure-native:sqlvirtualmachine:SqlVirtualMachine
    properties:
      assessmentSettings:
        enable: true
        runImmediately: true
        schedule:
          dayOfWeek: Sunday
          enable: true
          startTime: 23:17
          weeklyInterval: 1
      autoBackupSettings:
        backupScheduleType: Manual
        backupSystemDbs: true
        enable: true
        enableEncryption: true
        fullBackupFrequency: Daily
        fullBackupStartTime: 6
        fullBackupWindowHours: 11
        logBackupFrequency: 10
        password: <Password>
        retentionPeriod: 17
        storageAccessKey: <primary storage access key>
        storageAccountUrl: https://teststorage.blob.core.windows.net/
        storageContainerName: testcontainer
      autoPatchingSettings:
        dayOfWeek: Sunday
        enable: true
        maintenanceWindowDuration: 60
        maintenanceWindowStartingHour: 2
      keyVaultCredentialSettings:
        enable: false
      location: northeurope
      resourceGroupName: testrg
      serverConfigurationsManagementSettings:
        additionalFeaturesServerConfigurations:
          isRServicesEnabled: false
        sqlConnectivityUpdateSettings:
          connectivityType: PRIVATE
          port: 1433
          sqlAuthUpdatePassword: <password>
          sqlAuthUpdateUserName: sqllogin
        sqlInstanceSettings:
          collation: SQL_Latin1_General_CP1_CI_AS
          isIfiEnabled: true
          isLpimEnabled: true
          isOptimizeForAdHocWorkloadsEnabled: true
          maxDop: 8
          maxServerMemoryMB: 128
          minServerMemoryMB: 0
        sqlStorageUpdateSettings:
          diskConfigurationType: NEW
          diskCount: 1
          startingDeviceId: 2
        sqlWorkloadTypeUpdateSettings:
          sqlWorkloadType: OLTP
      sqlImageSku: Enterprise
      sqlManagement: Full
      sqlServerLicenseType: PAYG
      sqlVirtualMachineName: testvm
      virtualMachineResourceId: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm

Creates or updates a SQL virtual machine with min parameters.

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;

return await Deployment.RunAsync(() => 
{
    var sqlVirtualMachine = new AzureNative.SqlVirtualMachine.SqlVirtualMachine("sqlVirtualMachine", new()
    {
        Location = "northeurope",
        ResourceGroupName = "testrg",
        SqlVirtualMachineName = "testvm",
        VirtualMachineResourceId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm",
    });

});

package main

import (
	"github.com/pulumi/pulumi-azure-native-sdk/sqlvirtualmachine/v2"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sqlvirtualmachine.NewSqlVirtualMachine(ctx, "sqlVirtualMachine", &sqlvirtualmachine.SqlVirtualMachineArgs{
			Location:                 pulumi.String("northeurope"),
			ResourceGroupName:        pulumi.String("testrg"),
			SqlVirtualMachineName:    pulumi.String("testvm"),
			VirtualMachineResourceId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm"),
		})
		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.sqlvirtualmachine.SqlVirtualMachine;
import com.pulumi.azurenative.sqlvirtualmachine.SqlVirtualMachineArgs;
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 sqlVirtualMachine = new SqlVirtualMachine("sqlVirtualMachine", SqlVirtualMachineArgs.builder()        
            .location("northeurope")
            .resourceGroupName("testrg")
            .sqlVirtualMachineName("testvm")
            .virtualMachineResourceId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm")
            .build());

    }
}

import pulumi
import pulumi_azure_native as azure_native

sql_virtual_machine = azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine",
    location="northeurope",
    resource_group_name="testrg",
    sql_virtual_machine_name="testvm",
    virtual_machine_resource_id="/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm")

import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const sqlVirtualMachine = new azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine", {
    location: "northeurope",
    resourceGroupName: "testrg",
    sqlVirtualMachineName: "testvm",
    virtualMachineResourceId: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm",
});

resources:
  sqlVirtualMachine:
    type: azure-native:sqlvirtualmachine:SqlVirtualMachine
    properties:
      location: northeurope
      resourceGroupName: testrg
      sqlVirtualMachineName: testvm
      virtualMachineResourceId: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm

Create SqlVirtualMachine Resource

new SqlVirtualMachine(name: string, args: SqlVirtualMachineArgs, opts?: CustomResourceOptions);

@overload
def SqlVirtualMachine(resource_name: str,
                      opts: Optional[ResourceOptions] = None,
                      assessment_settings: Optional[AssessmentSettingsArgs] = None,
                      auto_backup_settings: Optional[AutoBackupSettingsArgs] = None,
                      auto_patching_settings: Optional[AutoPatchingSettingsArgs] = None,
                      identity: Optional[ResourceIdentityArgs] = None,
                      key_vault_credential_settings: Optional[KeyVaultCredentialSettingsArgs] = None,
                      location: Optional[str] = None,
                      resource_group_name: Optional[str] = None,
                      server_configurations_management_settings: Optional[ServerConfigurationsManagementSettingsArgs] = None,
                      sql_image_offer: Optional[str] = None,
                      sql_image_sku: Optional[Union[str, SqlImageSku]] = None,
                      sql_management: Optional[Union[str, SqlManagementMode]] = None,
                      sql_server_license_type: Optional[Union[str, SqlServerLicenseType]] = None,
                      sql_virtual_machine_group_resource_id: Optional[str] = None,
                      sql_virtual_machine_name: Optional[str] = None,
                      storage_configuration_settings: Optional[StorageConfigurationSettingsArgs] = None,
                      tags: Optional[Mapping[str, str]] = None,
                      virtual_machine_resource_id: Optional[str] = None,
                      wsfc_domain_credentials: Optional[WsfcDomainCredentialsArgs] = None,
                      wsfc_static_ip: Optional[str] = None)
@overload
def SqlVirtualMachine(resource_name: str,
                      args: SqlVirtualMachineArgs,
                      opts: Optional[ResourceOptions] = None)

func NewSqlVirtualMachine(ctx *Context, name string, args SqlVirtualMachineArgs, opts ...ResourceOption) (*SqlVirtualMachine, error)

public SqlVirtualMachine(string name, SqlVirtualMachineArgs args, CustomResourceOptions? opts = null)

public SqlVirtualMachine(String name, SqlVirtualMachineArgs args)
public SqlVirtualMachine(String name, SqlVirtualMachineArgs args, CustomResourceOptions options)

type: azure-native:sqlvirtualmachine:SqlVirtualMachine
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

name string: The unique name of the resource.
args SqlVirtualMachineArgs: 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 SqlVirtualMachineArgs: 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 SqlVirtualMachineArgs: The arguments to resource properties.
opts ResourceOption: Bag of options to control resource's behavior.

name string: The unique name of the resource.
args SqlVirtualMachineArgs: The arguments to resource properties.
opts CustomResourceOptions: Bag of options to control resource's behavior.

name String: The unique name of the resource.
args SqlVirtualMachineArgs: The arguments to resource properties.
options CustomResourceOptions: Bag of options to control resource's behavior.

SqlVirtualMachine 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 SqlVirtualMachine resource accepts the following input properties:

ResourceGroupName string: Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
AssessmentSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.AssessmentSettings: Assessment Settings.
AutoBackupSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.AutoBackupSettings: Auto backup settings for SQL Server.
AutoPatchingSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.AutoPatchingSettings: Auto patching settings for applying critical security updates to SQL virtual machine.
Identity Pulumi.AzureNative.SqlVirtualMachine.Inputs.ResourceIdentity: Azure Active Directory identity of the server.
KeyVaultCredentialSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.KeyVaultCredentialSettings: Key vault credential settings.
Location string: Resource location.
ServerConfigurationsManagementSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.ServerConfigurationsManagementSettings: SQL Server configuration management settings.
SqlImageOffer string: SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.
SqlImageSku string | Pulumi.AzureNative.SqlVirtualMachine.SqlImageSku: SQL Server edition type.
SqlManagement string | Pulumi.AzureNative.SqlVirtualMachine.SqlManagementMode: SQL Server Management type.
SqlServerLicenseType string | Pulumi.AzureNative.SqlVirtualMachine.SqlServerLicenseType: SQL Server license type.
SqlVirtualMachineGroupResourceId string: ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.
SqlVirtualMachineName string: Name of the SQL virtual machine.
StorageConfigurationSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.StorageConfigurationSettings: Storage Configuration Settings.
Tags Dictionary<string, string>: Resource tags.
VirtualMachineResourceId string: ARM Resource id of underlying virtual machine created from SQL marketplace image.
WsfcDomainCredentials Pulumi.AzureNative.SqlVirtualMachine.Inputs.WsfcDomainCredentials: Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
WsfcStaticIp string: Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.

ResourceGroupName string: Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
AssessmentSettings AssessmentSettingsArgs: Assessment Settings.
AutoBackupSettings AutoBackupSettingsArgs: Auto backup settings for SQL Server.
AutoPatchingSettings AutoPatchingSettingsArgs: Auto patching settings for applying critical security updates to SQL virtual machine.
Identity ResourceIdentityArgs: Azure Active Directory identity of the server.
KeyVaultCredentialSettings KeyVaultCredentialSettingsArgs: Key vault credential settings.
Location string: Resource location.
ServerConfigurationsManagementSettings ServerConfigurationsManagementSettingsArgs: SQL Server configuration management settings.
SqlImageOffer string: SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.
SqlImageSku string | SqlImageSku: SQL Server edition type.
SqlManagement string | SqlManagementMode: SQL Server Management type.
SqlServerLicenseType string | SqlServerLicenseType: SQL Server license type.
SqlVirtualMachineGroupResourceId string: ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.
SqlVirtualMachineName string: Name of the SQL virtual machine.
StorageConfigurationSettings StorageConfigurationSettingsArgs: Storage Configuration Settings.
Tags map[string]string: Resource tags.
VirtualMachineResourceId string: ARM Resource id of underlying virtual machine created from SQL marketplace image.
WsfcDomainCredentials WsfcDomainCredentialsArgs: Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
WsfcStaticIp string: Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.

resourceGroupName String: Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
assessmentSettings AssessmentSettings: Assessment Settings.
autoBackupSettings AutoBackupSettings: Auto backup settings for SQL Server.
autoPatchingSettings AutoPatchingSettings: Auto patching settings for applying critical security updates to SQL virtual machine.
identity ResourceIdentity: Azure Active Directory identity of the server.
keyVaultCredentialSettings KeyVaultCredentialSettings: Key vault credential settings.
location String: Resource location.
serverConfigurationsManagementSettings ServerConfigurationsManagementSettings: SQL Server configuration management settings.
sqlImageOffer String: SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.
sqlImageSku String | SqlImageSku: SQL Server edition type.
sqlManagement String | SqlManagementMode: SQL Server Management type.
sqlServerLicenseType String | SqlServerLicenseType: SQL Server license type.
sqlVirtualMachineGroupResourceId String: ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.
sqlVirtualMachineName String: Name of the SQL virtual machine.
storageConfigurationSettings StorageConfigurationSettings: Storage Configuration Settings.
tags Map<String,String>: Resource tags.
virtualMachineResourceId String: ARM Resource id of underlying virtual machine created from SQL marketplace image.
wsfcDomainCredentials WsfcDomainCredentials: Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
wsfcStaticIp String: Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.

resourceGroupName string: Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
assessmentSettings AssessmentSettings: Assessment Settings.
autoBackupSettings AutoBackupSettings: Auto backup settings for SQL Server.
autoPatchingSettings AutoPatchingSettings: Auto patching settings for applying critical security updates to SQL virtual machine.
identity ResourceIdentity: Azure Active Directory identity of the server.
keyVaultCredentialSettings KeyVaultCredentialSettings: Key vault credential settings.
location string: Resource location.
serverConfigurationsManagementSettings ServerConfigurationsManagementSettings: SQL Server configuration management settings.
sqlImageOffer string: SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.
sqlImageSku string | SqlImageSku: SQL Server edition type.
sqlManagement string | SqlManagementMode: SQL Server Management type.
sqlServerLicenseType string | SqlServerLicenseType: SQL Server license type.
sqlVirtualMachineGroupResourceId string: ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.
sqlVirtualMachineName string: Name of the SQL virtual machine.
storageConfigurationSettings StorageConfigurationSettings: Storage Configuration Settings.
tags {[key: string]: string}: Resource tags.
virtualMachineResourceId string: ARM Resource id of underlying virtual machine created from SQL marketplace image.
wsfcDomainCredentials WsfcDomainCredentials: Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
wsfcStaticIp string: Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.

resource_group_name str: Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
assessment_settings AssessmentSettingsArgs: Assessment Settings.
auto_backup_settings AutoBackupSettingsArgs: Auto backup settings for SQL Server.
auto_patching_settings AutoPatchingSettingsArgs: Auto patching settings for applying critical security updates to SQL virtual machine.
identity ResourceIdentityArgs: Azure Active Directory identity of the server.
key_vault_credential_settings KeyVaultCredentialSettingsArgs: Key vault credential settings.
location str: Resource location.
server_configurations_management_settings ServerConfigurationsManagementSettingsArgs: SQL Server configuration management settings.
sql_image_offer str: SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.
sql_image_sku str | SqlImageSku: SQL Server edition type.
sql_management str | SqlManagementMode: SQL Server Management type.
sql_server_license_type str | SqlServerLicenseType: SQL Server license type.
sql_virtual_machine_group_resource_id str: ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.
sql_virtual_machine_name str: Name of the SQL virtual machine.
storage_configuration_settings StorageConfigurationSettingsArgs: Storage Configuration Settings.
tags Mapping[str, str]: Resource tags.
virtual_machine_resource_id str: ARM Resource id of underlying virtual machine created from SQL marketplace image.
wsfc_domain_credentials WsfcDomainCredentialsArgs: Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
wsfc_static_ip str: Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.

resourceGroupName String: Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
assessmentSettings Property Map: Assessment Settings.
autoBackupSettings Property Map: Auto backup settings for SQL Server.
autoPatchingSettings Property Map: Auto patching settings for applying critical security updates to SQL virtual machine.
identity Property Map: Azure Active Directory identity of the server.
keyVaultCredentialSettings Property Map: Key vault credential settings.
location String: Resource location.
serverConfigurationsManagementSettings Property Map: SQL Server configuration management settings.
sqlImageOffer String: SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.
sqlImageSku String | "Developer" | "Express" | "Standard" | "Enterprise" | "Web": SQL Server edition type.
sqlManagement String | "Full" | "LightWeight" | "NoAgent": SQL Server Management type.
sqlServerLicenseType String | "PAYG" | "AHUB" | "DR": SQL Server license type.
sqlVirtualMachineGroupResourceId String: ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.
sqlVirtualMachineName String: Name of the SQL virtual machine.
storageConfigurationSettings Property Map: Storage Configuration Settings.
tags Map<String>: Resource tags.
virtualMachineResourceId String: ARM Resource id of underlying virtual machine created from SQL marketplace image.
wsfcDomainCredentials Property Map: Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
wsfcStaticIp String: Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.

Outputs

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

Id string: The provider-assigned unique ID for this managed resource.
Name string: Resource name.
ProvisioningState string: Provisioning state to track the async operation status.
SystemData Pulumi.AzureNative.SqlVirtualMachine.Outputs.SystemDataResponse: Metadata pertaining to creation and last modification of the resource.
Type string: Resource type.

Id string: The provider-assigned unique ID for this managed resource.
Name string: Resource name.
ProvisioningState string: Provisioning state to track the async operation status.
SystemData SystemDataResponse: Metadata pertaining to creation and last modification of the resource.
Type string: Resource type.

id String: The provider-assigned unique ID for this managed resource.
name String: Resource name.
provisioningState String: Provisioning state to track the async operation status.
systemData SystemDataResponse: Metadata pertaining to creation and last modification of the resource.
type String: Resource type.

id string: The provider-assigned unique ID for this managed resource.
name string: Resource name.
provisioningState string: Provisioning state to track the async operation status.
systemData SystemDataResponse: Metadata pertaining to creation and last modification of the resource.
type string: Resource type.

id str: The provider-assigned unique ID for this managed resource.
name str: Resource name.
provisioning_state str: Provisioning state to track the async operation status.
system_data SystemDataResponse: Metadata pertaining to creation and last modification of the resource.
type str: Resource type.

id String: The provider-assigned unique ID for this managed resource.
name String: Resource name.
provisioningState String: Provisioning state to track the async operation status.
systemData Property Map: Metadata pertaining to creation and last modification of the resource.
type String: Resource type.

Supporting Types

AdditionalFeaturesServerConfigurations, AdditionalFeaturesServerConfigurationsArgs

IsRServicesEnabled bool: Enable or disable R services (SQL 2016 onwards).

IsRServicesEnabled bool: Enable or disable R services (SQL 2016 onwards).

isRServicesEnabled Boolean: Enable or disable R services (SQL 2016 onwards).

isRServicesEnabled boolean: Enable or disable R services (SQL 2016 onwards).

is_r_services_enabled bool: Enable or disable R services (SQL 2016 onwards).

isRServicesEnabled Boolean: Enable or disable R services (SQL 2016 onwards).

AdditionalFeaturesServerConfigurationsResponse, AdditionalFeaturesServerConfigurationsResponseArgs

IsRServicesEnabled bool: Enable or disable R services (SQL 2016 onwards).

IsRServicesEnabled bool: Enable or disable R services (SQL 2016 onwards).

isRServicesEnabled Boolean: Enable or disable R services (SQL 2016 onwards).

isRServicesEnabled boolean: Enable or disable R services (SQL 2016 onwards).

is_r_services_enabled bool: Enable or disable R services (SQL 2016 onwards).

isRServicesEnabled Boolean: Enable or disable R services (SQL 2016 onwards).

AssessmentDayOfWeek, AssessmentDayOfWeekArgs

Monday: Monday
Tuesday: Tuesday
Wednesday: Wednesday
Thursday: Thursday
Friday: Friday
Saturday: Saturday
Sunday: Sunday

AssessmentDayOfWeekMonday: Monday
AssessmentDayOfWeekTuesday: Tuesday
AssessmentDayOfWeekWednesday: Wednesday
AssessmentDayOfWeekThursday: Thursday
AssessmentDayOfWeekFriday: Friday
AssessmentDayOfWeekSaturday: Saturday
AssessmentDayOfWeekSunday: Sunday

Monday: Monday
Tuesday: Tuesday
Wednesday: Wednesday
Thursday: Thursday
Friday: Friday
Saturday: Saturday
Sunday: Sunday

Monday: Monday
Tuesday: Tuesday
Wednesday: Wednesday
Thursday: Thursday
Friday: Friday
Saturday: Saturday
Sunday: Sunday

MONDAY: Monday
TUESDAY: Tuesday
WEDNESDAY: Wednesday
THURSDAY: Thursday
FRIDAY: Friday
SATURDAY: Saturday
SUNDAY: Sunday

"Monday": Monday
"Tuesday": Tuesday
"Wednesday": Wednesday
"Thursday": Thursday
"Friday": Friday
"Saturday": Saturday
"Sunday": Sunday

AssessmentSettings, AssessmentSettingsArgs

Enable bool: Enable or disable assessment feature on SQL virtual machine.
RunImmediately bool: Run assessment immediately on SQL virtual machine.
Schedule Pulumi.AzureNative.SqlVirtualMachine.Inputs.Schedule: Schedule for Assessment.

Enable bool: Enable or disable assessment feature on SQL virtual machine.
RunImmediately bool: Run assessment immediately on SQL virtual machine.
Schedule Schedule: Schedule for Assessment.

enable Boolean: Enable or disable assessment feature on SQL virtual machine.
runImmediately Boolean: Run assessment immediately on SQL virtual machine.
schedule Schedule: Schedule for Assessment.

enable boolean: Enable or disable assessment feature on SQL virtual machine.
runImmediately boolean: Run assessment immediately on SQL virtual machine.
schedule Schedule: Schedule for Assessment.

enable bool: Enable or disable assessment feature on SQL virtual machine.
run_immediately bool: Run assessment immediately on SQL virtual machine.
schedule Schedule: Schedule for Assessment.

enable Boolean: Enable or disable assessment feature on SQL virtual machine.
runImmediately Boolean: Run assessment immediately on SQL virtual machine.
schedule Property Map: Schedule for Assessment.

AssessmentSettingsResponse, AssessmentSettingsResponseArgs

Enable bool: Enable or disable assessment feature on SQL virtual machine.
RunImmediately bool: Run assessment immediately on SQL virtual machine.
Schedule Pulumi.AzureNative.SqlVirtualMachine.Inputs.ScheduleResponse: Schedule for Assessment.

Enable bool: Enable or disable assessment feature on SQL virtual machine.
RunImmediately bool: Run assessment immediately on SQL virtual machine.
Schedule ScheduleResponse: Schedule for Assessment.

enable Boolean: Enable or disable assessment feature on SQL virtual machine.
runImmediately Boolean: Run assessment immediately on SQL virtual machine.
schedule ScheduleResponse: Schedule for Assessment.

enable boolean: Enable or disable assessment feature on SQL virtual machine.
runImmediately boolean: Run assessment immediately on SQL virtual machine.
schedule ScheduleResponse: Schedule for Assessment.

enable bool: Enable or disable assessment feature on SQL virtual machine.
run_immediately bool: Run assessment immediately on SQL virtual machine.
schedule ScheduleResponse: Schedule for Assessment.

enable Boolean: Enable or disable assessment feature on SQL virtual machine.
runImmediately Boolean: Run assessment immediately on SQL virtual machine.
schedule Property Map: Schedule for Assessment.

AutoBackupDaysOfWeek, AutoBackupDaysOfWeekArgs

Monday: Monday
Tuesday: Tuesday
Wednesday: Wednesday
Thursday: Thursday
Friday: Friday
Saturday: Saturday
Sunday: Sunday

AutoBackupDaysOfWeekMonday: Monday
AutoBackupDaysOfWeekTuesday: Tuesday
AutoBackupDaysOfWeekWednesday: Wednesday
AutoBackupDaysOfWeekThursday: Thursday
AutoBackupDaysOfWeekFriday: Friday
AutoBackupDaysOfWeekSaturday: Saturday
AutoBackupDaysOfWeekSunday: Sunday

Monday: Monday
Tuesday: Tuesday
Wednesday: Wednesday
Thursday: Thursday
Friday: Friday
Saturday: Saturday
Sunday: Sunday

Monday: Monday
Tuesday: Tuesday
Wednesday: Wednesday
Thursday: Thursday
Friday: Friday
Saturday: Saturday
Sunday: Sunday

MONDAY: Monday
TUESDAY: Tuesday
WEDNESDAY: Wednesday
THURSDAY: Thursday
FRIDAY: Friday
SATURDAY: Saturday
SUNDAY: Sunday

"Monday": Monday
"Tuesday": Tuesday
"Wednesday": Wednesday
"Thursday": Thursday
"Friday": Friday
"Saturday": Saturday
"Sunday": Sunday

AutoBackupSettings, AutoBackupSettingsArgs

BackupScheduleType string | Pulumi.AzureNative.SqlVirtualMachine.BackupScheduleType: Backup schedule type.
BackupSystemDbs bool: Include or exclude system databases from auto backup.
DaysOfWeek List<Union<string, Pulumi.AzureNative.SqlVirtualMachine.AutoBackupDaysOfWeek>>: Days of the week for the backups when FullBackupFrequency is set to Weekly.
Enable bool: Enable or disable autobackup on SQL virtual machine.
EnableEncryption bool: Enable or disable encryption for backup on SQL virtual machine.
FullBackupFrequency string | Pulumi.AzureNative.SqlVirtualMachine.FullBackupFrequencyType: Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
FullBackupStartTime int: Start time of a given day during which full backups can take place. 0-23 hours.
FullBackupWindowHours int: Duration of the time window of a given day during which full backups can take place. 1-23 hours.
LogBackupFrequency int: Frequency of log backups. 5-60 minutes.
Password string: Password for encryption on backup.
RetentionPeriod int: Retention period of backup: 1-90 days.
StorageAccessKey string: Storage account key where backup will be taken to.
StorageAccountUrl string: Storage account url where backup will be taken to.
StorageContainerName string: Storage container name where backup will be taken to.

BackupScheduleType string | BackupScheduleType: Backup schedule type.
BackupSystemDbs bool: Include or exclude system databases from auto backup.
DaysOfWeek []string: Days of the week for the backups when FullBackupFrequency is set to Weekly.
Enable bool: Enable or disable autobackup on SQL virtual machine.
EnableEncryption bool: Enable or disable encryption for backup on SQL virtual machine.
FullBackupFrequency string | FullBackupFrequencyType: Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
FullBackupStartTime int: Start time of a given day during which full backups can take place. 0-23 hours.
FullBackupWindowHours int: Duration of the time window of a given day during which full backups can take place. 1-23 hours.
LogBackupFrequency int: Frequency of log backups. 5-60 minutes.
Password string: Password for encryption on backup.
RetentionPeriod int: Retention period of backup: 1-90 days.
StorageAccessKey string: Storage account key where backup will be taken to.
StorageAccountUrl string: Storage account url where backup will be taken to.
StorageContainerName string: Storage container name where backup will be taken to.

backupScheduleType String | BackupScheduleType: Backup schedule type.
backupSystemDbs Boolean: Include or exclude system databases from auto backup.
daysOfWeek List<Either<String,AutoBackupDaysOfWeek>>: Days of the week for the backups when FullBackupFrequency is set to Weekly.
enable Boolean: Enable or disable autobackup on SQL virtual machine.
enableEncryption Boolean: Enable or disable encryption for backup on SQL virtual machine.
fullBackupFrequency String | FullBackupFrequencyType: Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
fullBackupStartTime Integer: Start time of a given day during which full backups can take place. 0-23 hours.
fullBackupWindowHours Integer: Duration of the time window of a given day during which full backups can take place. 1-23 hours.
logBackupFrequency Integer: Frequency of log backups. 5-60 minutes.
password String: Password for encryption on backup.
retentionPeriod Integer: Retention period of backup: 1-90 days.
storageAccessKey String: Storage account key where backup will be taken to.
storageAccountUrl String: Storage account url where backup will be taken to.
storageContainerName String: Storage container name where backup will be taken to.

backupScheduleType string | BackupScheduleType: Backup schedule type.
backupSystemDbs boolean: Include or exclude system databases from auto backup.
daysOfWeek (string | AutoBackupDaysOfWeek)[]: Days of the week for the backups when FullBackupFrequency is set to Weekly.
enable boolean: Enable or disable autobackup on SQL virtual machine.
enableEncryption boolean: Enable or disable encryption for backup on SQL virtual machine.
fullBackupFrequency string | FullBackupFrequencyType: Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
fullBackupStartTime number: Start time of a given day during which full backups can take place. 0-23 hours.
fullBackupWindowHours number: Duration of the time window of a given day during which full backups can take place. 1-23 hours.
logBackupFrequency number: Frequency of log backups. 5-60 minutes.
password string: Password for encryption on backup.
retentionPeriod number: Retention period of backup: 1-90 days.
storageAccessKey string: Storage account key where backup will be taken to.
storageAccountUrl string: Storage account url where backup will be taken to.
storageContainerName string: Storage container name where backup will be taken to.

backup_schedule_type str | BackupScheduleType: Backup schedule type.
backup_system_dbs bool: Include or exclude system databases from auto backup.
days_of_week Sequence[Union[str, AutoBackupDaysOfWeek]]: Days of the week for the backups when FullBackupFrequency is set to Weekly.
enable bool: Enable or disable autobackup on SQL virtual machine.
enable_encryption bool: Enable or disable encryption for backup on SQL virtual machine.
full_backup_frequency str | FullBackupFrequencyType: Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
full_backup_start_time int: Start time of a given day during which full backups can take place. 0-23 hours.
full_backup_window_hours int: Duration of the time window of a given day during which full backups can take place. 1-23 hours.
log_backup_frequency int: Frequency of log backups. 5-60 minutes.
password str: Password for encryption on backup.
retention_period int: Retention period of backup: 1-90 days.
storage_access_key str: Storage account key where backup will be taken to.
storage_account_url str: Storage account url where backup will be taken to.
storage_container_name str: Storage container name where backup will be taken to.

backupScheduleType String | "Manual" | "Automated": Backup schedule type.
backupSystemDbs Boolean: Include or exclude system databases from auto backup.
daysOfWeek List<String | "Monday" | "Tuesday" | "Wednesday" | "Thursday" | "Friday" | "Saturday" | "Sunday">: Days of the week for the backups when FullBackupFrequency is set to Weekly.
enable Boolean: Enable or disable autobackup on SQL virtual machine.
enableEncryption Boolean: Enable or disable encryption for backup on SQL virtual machine.
fullBackupFrequency String | "Daily" | "Weekly": Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
fullBackupStartTime Number: Start time of a given day during which full backups can take place. 0-23 hours.
fullBackupWindowHours Number: Duration of the time window of a given day during which full backups can take place. 1-23 hours.
logBackupFrequency Number: Frequency of log backups. 5-60 minutes.
password String: Password for encryption on backup.
retentionPeriod Number: Retention period of backup: 1-90 days.
storageAccessKey String: Storage account key where backup will be taken to.
storageAccountUrl String: Storage account url where backup will be taken to.
storageContainerName String: Storage container name where backup will be taken to.

AutoBackupSettingsResponse, AutoBackupSettingsResponseArgs

BackupScheduleType string: Backup schedule type.
BackupSystemDbs bool: Include or exclude system databases from auto backup.
DaysOfWeek List<string>: Days of the week for the backups when FullBackupFrequency is set to Weekly.
Enable bool: Enable or disable autobackup on SQL virtual machine.
EnableEncryption bool: Enable or disable encryption for backup on SQL virtual machine.
FullBackupFrequency string: Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
FullBackupStartTime int: Start time of a given day during which full backups can take place. 0-23 hours.
FullBackupWindowHours int: Duration of the time window of a given day during which full backups can take place. 1-23 hours.
LogBackupFrequency int: Frequency of log backups. 5-60 minutes.
RetentionPeriod int: Retention period of backup: 1-90 days.
StorageAccountUrl string: Storage account url where backup will be taken to.
StorageContainerName string: Storage container name where backup will be taken to.

BackupScheduleType string: Backup schedule type.
BackupSystemDbs bool: Include or exclude system databases from auto backup.
DaysOfWeek []string: Days of the week for the backups when FullBackupFrequency is set to Weekly.
Enable bool: Enable or disable autobackup on SQL virtual machine.
EnableEncryption bool: Enable or disable encryption for backup on SQL virtual machine.
FullBackupFrequency string: Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
FullBackupStartTime int: Start time of a given day during which full backups can take place. 0-23 hours.
FullBackupWindowHours int: Duration of the time window of a given day during which full backups can take place. 1-23 hours.
LogBackupFrequency int: Frequency of log backups. 5-60 minutes.
RetentionPeriod int: Retention period of backup: 1-90 days.
StorageAccountUrl string: Storage account url where backup will be taken to.
StorageContainerName string: Storage container name where backup will be taken to.

backupScheduleType String: Backup schedule type.
backupSystemDbs Boolean: Include or exclude system databases from auto backup.
daysOfWeek List<String>: Days of the week for the backups when FullBackupFrequency is set to Weekly.
enable Boolean: Enable or disable autobackup on SQL virtual machine.
enableEncryption Boolean: Enable or disable encryption for backup on SQL virtual machine.
fullBackupFrequency String: Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
fullBackupStartTime Integer: Start time of a given day during which full backups can take place. 0-23 hours.
fullBackupWindowHours Integer: Duration of the time window of a given day during which full backups can take place. 1-23 hours.
logBackupFrequency Integer: Frequency of log backups. 5-60 minutes.
retentionPeriod Integer: Retention period of backup: 1-90 days.
storageAccountUrl String: Storage account url where backup will be taken to.
storageContainerName String: Storage container name where backup will be taken to.

backupScheduleType string: Backup schedule type.
backupSystemDbs boolean: Include or exclude system databases from auto backup.
daysOfWeek string[]: Days of the week for the backups when FullBackupFrequency is set to Weekly.
enable boolean: Enable or disable autobackup on SQL virtual machine.
enableEncryption boolean: Enable or disable encryption for backup on SQL virtual machine.
fullBackupFrequency string: Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
fullBackupStartTime number: Start time of a given day during which full backups can take place. 0-23 hours.
fullBackupWindowHours number: Duration of the time window of a given day during which full backups can take place. 1-23 hours.
logBackupFrequency number: Frequency of log backups. 5-60 minutes.
retentionPeriod number: Retention period of backup: 1-90 days.
storageAccountUrl string: Storage account url where backup will be taken to.
storageContainerName string: Storage container name where backup will be taken to.

backup_schedule_type str: Backup schedule type.
backup_system_dbs bool: Include or exclude system databases from auto backup.
days_of_week Sequence[str]: Days of the week for the backups when FullBackupFrequency is set to Weekly.
enable bool: Enable or disable autobackup on SQL virtual machine.
enable_encryption bool: Enable or disable encryption for backup on SQL virtual machine.
full_backup_frequency str: Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
full_backup_start_time int: Start time of a given day during which full backups can take place. 0-23 hours.
full_backup_window_hours int: Duration of the time window of a given day during which full backups can take place. 1-23 hours.
log_backup_frequency int: Frequency of log backups. 5-60 minutes.
retention_period int: Retention period of backup: 1-90 days.
storage_account_url str: Storage account url where backup will be taken to.
storage_container_name str: Storage container name where backup will be taken to.

backupScheduleType String: Backup schedule type.
backupSystemDbs Boolean: Include or exclude system databases from auto backup.
daysOfWeek List<String>: Days of the week for the backups when FullBackupFrequency is set to Weekly.
enable Boolean: Enable or disable autobackup on SQL virtual machine.
enableEncryption Boolean: Enable or disable encryption for backup on SQL virtual machine.
fullBackupFrequency String: Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
fullBackupStartTime Number: Start time of a given day during which full backups can take place. 0-23 hours.
fullBackupWindowHours Number: Duration of the time window of a given day during which full backups can take place. 1-23 hours.
logBackupFrequency Number: Frequency of log backups. 5-60 minutes.
retentionPeriod Number: Retention period of backup: 1-90 days.
storageAccountUrl String: Storage account url where backup will be taken to.
storageContainerName String: Storage container name where backup will be taken to.

AutoPatchingSettings, AutoPatchingSettingsArgs

DayOfWeek Pulumi.AzureNative.SqlVirtualMachine.DayOfWeek: Day of week to apply the patch on.
Enable bool: Enable or disable autopatching on SQL virtual machine.
MaintenanceWindowDuration int: Duration of patching.
MaintenanceWindowStartingHour int: Hour of the day when patching is initiated. Local VM time.

DayOfWeek DayOfWeek: Day of week to apply the patch on.
Enable bool: Enable or disable autopatching on SQL virtual machine.
MaintenanceWindowDuration int: Duration of patching.
MaintenanceWindowStartingHour int: Hour of the day when patching is initiated. Local VM time.

dayOfWeek DayOfWeek: Day of week to apply the patch on.
enable Boolean: Enable or disable autopatching on SQL virtual machine.
maintenanceWindowDuration Integer: Duration of patching.
maintenanceWindowStartingHour Integer: Hour of the day when patching is initiated. Local VM time.

dayOfWeek DayOfWeek: Day of week to apply the patch on.
enable boolean: Enable or disable autopatching on SQL virtual machine.
maintenanceWindowDuration number: Duration of patching.
maintenanceWindowStartingHour number: Hour of the day when patching is initiated. Local VM time.

day_of_week DayOfWeek: Day of week to apply the patch on.
enable bool: Enable or disable autopatching on SQL virtual machine.
maintenance_window_duration int: Duration of patching.
maintenance_window_starting_hour int: Hour of the day when patching is initiated. Local VM time.

dayOfWeek "Everyday" | "Monday" | "Tuesday" | "Wednesday" | "Thursday" | "Friday" | "Saturday" | "Sunday": Day of week to apply the patch on.
enable Boolean: Enable or disable autopatching on SQL virtual machine.
maintenanceWindowDuration Number: Duration of patching.
maintenanceWindowStartingHour Number: Hour of the day when patching is initiated. Local VM time.

AutoPatchingSettingsResponse, AutoPatchingSettingsResponseArgs

DayOfWeek string: Day of week to apply the patch on.
Enable bool: Enable or disable autopatching on SQL virtual machine.
MaintenanceWindowDuration int: Duration of patching.
MaintenanceWindowStartingHour int: Hour of the day when patching is initiated. Local VM time.

DayOfWeek string: Day of week to apply the patch on.
Enable bool: Enable or disable autopatching on SQL virtual machine.
MaintenanceWindowDuration int: Duration of patching.
MaintenanceWindowStartingHour int: Hour of the day when patching is initiated. Local VM time.

dayOfWeek String: Day of week to apply the patch on.
enable Boolean: Enable or disable autopatching on SQL virtual machine.
maintenanceWindowDuration Integer: Duration of patching.
maintenanceWindowStartingHour Integer: Hour of the day when patching is initiated. Local VM time.

dayOfWeek string: Day of week to apply the patch on.
enable boolean: Enable or disable autopatching on SQL virtual machine.
maintenanceWindowDuration number: Duration of patching.
maintenanceWindowStartingHour number: Hour of the day when patching is initiated. Local VM time.

day_of_week str: Day of week to apply the patch on.
enable bool: Enable or disable autopatching on SQL virtual machine.
maintenance_window_duration int: Duration of patching.
maintenance_window_starting_hour int: Hour of the day when patching is initiated. Local VM time.

dayOfWeek String: Day of week to apply the patch on.
enable Boolean: Enable or disable autopatching on SQL virtual machine.
maintenanceWindowDuration Number: Duration of patching.
maintenanceWindowStartingHour Number: Hour of the day when patching is initiated. Local VM time.

BackupScheduleType, BackupScheduleTypeArgs

Manual: Manual
Automated: Automated

BackupScheduleTypeManual: Manual
BackupScheduleTypeAutomated: Automated

Manual: Manual
Automated: Automated

Manual: Manual
Automated: Automated

MANUAL: Manual
AUTOMATED: Automated

"Manual": Manual
"Automated": Automated

ConnectivityType, ConnectivityTypeArgs

LOCAL: LOCAL
PRIVATE: PRIVATE
PUBLIC: PUBLIC

ConnectivityTypeLOCAL: LOCAL
ConnectivityTypePRIVATE: PRIVATE
ConnectivityTypePUBLIC: PUBLIC

LOCAL: LOCAL
PRIVATE: PRIVATE
PUBLIC: PUBLIC

LOCAL: LOCAL
PRIVATE: PRIVATE
PUBLIC: PUBLIC

LOCAL: LOCAL
PRIVATE: PRIVATE
PUBLIC: PUBLIC

"LOCAL": LOCAL
"PRIVATE": PRIVATE
"PUBLIC": PUBLIC

DayOfWeek, DayOfWeekArgs

Everyday: Everyday
Monday: Monday
Tuesday: Tuesday
Wednesday: Wednesday
Thursday: Thursday
Friday: Friday
Saturday: Saturday
Sunday: Sunday

DayOfWeekEveryday: Everyday
DayOfWeekMonday: Monday
DayOfWeekTuesday: Tuesday
DayOfWeekWednesday: Wednesday
DayOfWeekThursday: Thursday
DayOfWeekFriday: Friday
DayOfWeekSaturday: Saturday
DayOfWeekSunday: Sunday

Everyday: Everyday
Monday: Monday
Tuesday: Tuesday
Wednesday: Wednesday
Thursday: Thursday
Friday: Friday
Saturday: Saturday
Sunday: Sunday

Everyday: Everyday
Monday: Monday
Tuesday: Tuesday
Wednesday: Wednesday
Thursday: Thursday
Friday: Friday
Saturday: Saturday
Sunday: Sunday

EVERYDAY: Everyday
MONDAY: Monday
TUESDAY: Tuesday
WEDNESDAY: Wednesday
THURSDAY: Thursday
FRIDAY: Friday
SATURDAY: Saturday
SUNDAY: Sunday

"Everyday": Everyday
"Monday": Monday
"Tuesday": Tuesday
"Wednesday": Wednesday
"Thursday": Thursday
"Friday": Friday
"Saturday": Saturday
"Sunday": Sunday

DiskConfigurationType, DiskConfigurationTypeArgs

NEW: NEW
EXTEND: EXTEND
ADD: ADD

DiskConfigurationTypeNEW: NEW
DiskConfigurationTypeEXTEND: EXTEND
DiskConfigurationTypeADD: ADD

NEW: NEW
EXTEND: EXTEND
ADD: ADD

NEW: NEW
EXTEND: EXTEND
ADD: ADD

NEW: NEW
EXTEND: EXTEND
ADD: ADD

"NEW": NEW
"EXTEND": EXTEND
"ADD": ADD

FullBackupFrequencyType, FullBackupFrequencyTypeArgs

Daily: Daily
Weekly: Weekly

FullBackupFrequencyTypeDaily: Daily
FullBackupFrequencyTypeWeekly: Weekly

Daily: Daily
Weekly: Weekly

Daily: Daily
Weekly: Weekly

DAILY: Daily
WEEKLY: Weekly

"Daily": Daily
"Weekly": Weekly

IdentityType, IdentityTypeArgs

None: None
SystemAssigned: SystemAssigned

IdentityTypeNone: None
IdentityTypeSystemAssigned: SystemAssigned

None: None
SystemAssigned: SystemAssigned

None: None
SystemAssigned: SystemAssigned

NONE: None
SYSTEM_ASSIGNED: SystemAssigned

"None": None
"SystemAssigned": SystemAssigned

KeyVaultCredentialSettings, KeyVaultCredentialSettingsArgs

AzureKeyVaultUrl string: Azure Key Vault url.
CredentialName string: Credential name.
Enable bool: Enable or disable key vault credential setting.
ServicePrincipalName string: Service principal name to access key vault.
ServicePrincipalSecret string: Service principal name secret to access key vault.

AzureKeyVaultUrl string: Azure Key Vault url.
CredentialName string: Credential name.
Enable bool: Enable or disable key vault credential setting.
ServicePrincipalName string: Service principal name to access key vault.
ServicePrincipalSecret string: Service principal name secret to access key vault.

azureKeyVaultUrl String: Azure Key Vault url.
credentialName String: Credential name.
enable Boolean: Enable or disable key vault credential setting.
servicePrincipalName String: Service principal name to access key vault.
servicePrincipalSecret String: Service principal name secret to access key vault.

azureKeyVaultUrl string: Azure Key Vault url.
credentialName string: Credential name.
enable boolean: Enable or disable key vault credential setting.
servicePrincipalName string: Service principal name to access key vault.
servicePrincipalSecret string: Service principal name secret to access key vault.

azure_key_vault_url str: Azure Key Vault url.
credential_name str: Credential name.
enable bool: Enable or disable key vault credential setting.
service_principal_name str: Service principal name to access key vault.
service_principal_secret str: Service principal name secret to access key vault.

azureKeyVaultUrl String: Azure Key Vault url.
credentialName String: Credential name.
enable Boolean: Enable or disable key vault credential setting.
servicePrincipalName String: Service principal name to access key vault.
servicePrincipalSecret String: Service principal name secret to access key vault.

KeyVaultCredentialSettingsResponse, KeyVaultCredentialSettingsResponseArgs

AzureKeyVaultUrl string: Azure Key Vault url.
CredentialName string: Credential name.
Enable bool: Enable or disable key vault credential setting.
ServicePrincipalName string: Service principal name to access key vault.

AzureKeyVaultUrl string: Azure Key Vault url.
CredentialName string: Credential name.
Enable bool: Enable or disable key vault credential setting.
ServicePrincipalName string: Service principal name to access key vault.

azureKeyVaultUrl String: Azure Key Vault url.
credentialName String: Credential name.
enable Boolean: Enable or disable key vault credential setting.
servicePrincipalName String: Service principal name to access key vault.

azureKeyVaultUrl string: Azure Key Vault url.
credentialName string: Credential name.
enable boolean: Enable or disable key vault credential setting.
servicePrincipalName string: Service principal name to access key vault.

azure_key_vault_url str: Azure Key Vault url.
credential_name str: Credential name.
enable bool: Enable or disable key vault credential setting.
service_principal_name str: Service principal name to access key vault.

azureKeyVaultUrl String: Azure Key Vault url.
credentialName String: Credential name.
enable Boolean: Enable or disable key vault credential setting.
servicePrincipalName String: Service principal name to access key vault.

ResourceIdentity, ResourceIdentityArgs

Type string | Pulumi.AzureNative.SqlVirtualMachine.IdentityType: The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.

Type string | IdentityType: The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.

type String | IdentityType: The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.

type string | IdentityType: The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.

type str | IdentityType: The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.

type String | "None" | "SystemAssigned": The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.

ResourceIdentityResponse, ResourceIdentityResponseArgs

PrincipalId string: The Azure Active Directory principal id.
TenantId string: The Azure Active Directory tenant id.
Type string: The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.

PrincipalId string: The Azure Active Directory principal id.
TenantId string: The Azure Active Directory tenant id.
Type string: The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.

principalId String: The Azure Active Directory principal id.
tenantId String: The Azure Active Directory tenant id.
type String: The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.

principalId string: The Azure Active Directory principal id.
tenantId string: The Azure Active Directory tenant id.
type string: The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.

principal_id str: The Azure Active Directory principal id.
tenant_id str: The Azure Active Directory tenant id.
type str: The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.

principalId String: The Azure Active Directory principal id.
tenantId String: The Azure Active Directory tenant id.
type String: The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.

SQLInstanceSettings, SQLInstanceSettingsArgs

Collation string: SQL Server Collation.
IsIfiEnabled bool: SQL Server IFI.
IsLpimEnabled bool: SQL Server LPIM.
IsOptimizeForAdHocWorkloadsEnabled bool: SQL Server Optimize for Adhoc workloads.
MaxDop int: SQL Server MAXDOP.
MaxServerMemoryMB int: SQL Server maximum memory.
MinServerMemoryMB int: SQL Server minimum memory.

Collation string: SQL Server Collation.
IsIfiEnabled bool: SQL Server IFI.
IsLpimEnabled bool: SQL Server LPIM.
IsOptimizeForAdHocWorkloadsEnabled bool: SQL Server Optimize for Adhoc workloads.
MaxDop int: SQL Server MAXDOP.
MaxServerMemoryMB int: SQL Server maximum memory.
MinServerMemoryMB int: SQL Server minimum memory.

collation String: SQL Server Collation.
isIfiEnabled Boolean: SQL Server IFI.
isLpimEnabled Boolean: SQL Server LPIM.
isOptimizeForAdHocWorkloadsEnabled Boolean: SQL Server Optimize for Adhoc workloads.
maxDop Integer: SQL Server MAXDOP.
maxServerMemoryMB Integer: SQL Server maximum memory.
minServerMemoryMB Integer: SQL Server minimum memory.

collation string: SQL Server Collation.
isIfiEnabled boolean: SQL Server IFI.
isLpimEnabled boolean: SQL Server LPIM.
isOptimizeForAdHocWorkloadsEnabled boolean: SQL Server Optimize for Adhoc workloads.
maxDop number: SQL Server MAXDOP.
maxServerMemoryMB number: SQL Server maximum memory.
minServerMemoryMB number: SQL Server minimum memory.

collation str: SQL Server Collation.
is_ifi_enabled bool: SQL Server IFI.
is_lpim_enabled bool: SQL Server LPIM.
is_optimize_for_ad_hoc_workloads_enabled bool: SQL Server Optimize for Adhoc workloads.
max_dop int: SQL Server MAXDOP.
max_server_memory_mb int: SQL Server maximum memory.
min_server_memory_mb int: SQL Server minimum memory.

collation String: SQL Server Collation.
isIfiEnabled Boolean: SQL Server IFI.
isLpimEnabled Boolean: SQL Server LPIM.
isOptimizeForAdHocWorkloadsEnabled Boolean: SQL Server Optimize for Adhoc workloads.
maxDop Number: SQL Server MAXDOP.
maxServerMemoryMB Number: SQL Server maximum memory.
minServerMemoryMB Number: SQL Server minimum memory.

SQLInstanceSettingsResponse, SQLInstanceSettingsResponseArgs

Collation string: SQL Server Collation.
IsIfiEnabled bool: SQL Server IFI.
IsLpimEnabled bool: SQL Server LPIM.
IsOptimizeForAdHocWorkloadsEnabled bool: SQL Server Optimize for Adhoc workloads.
MaxDop int: SQL Server MAXDOP.
MaxServerMemoryMB int: SQL Server maximum memory.
MinServerMemoryMB int: SQL Server minimum memory.

Collation string: SQL Server Collation.
IsIfiEnabled bool: SQL Server IFI.
IsLpimEnabled bool: SQL Server LPIM.
IsOptimizeForAdHocWorkloadsEnabled bool: SQL Server Optimize for Adhoc workloads.
MaxDop int: SQL Server MAXDOP.
MaxServerMemoryMB int: SQL Server maximum memory.
MinServerMemoryMB int: SQL Server minimum memory.

collation String: SQL Server Collation.
isIfiEnabled Boolean: SQL Server IFI.
isLpimEnabled Boolean: SQL Server LPIM.
isOptimizeForAdHocWorkloadsEnabled Boolean: SQL Server Optimize for Adhoc workloads.
maxDop Integer: SQL Server MAXDOP.
maxServerMemoryMB Integer: SQL Server maximum memory.
minServerMemoryMB Integer: SQL Server minimum memory.

collation string: SQL Server Collation.
isIfiEnabled boolean: SQL Server IFI.
isLpimEnabled boolean: SQL Server LPIM.
isOptimizeForAdHocWorkloadsEnabled boolean: SQL Server Optimize for Adhoc workloads.
maxDop number: SQL Server MAXDOP.
maxServerMemoryMB number: SQL Server maximum memory.
minServerMemoryMB number: SQL Server minimum memory.

collation str: SQL Server Collation.
is_ifi_enabled bool: SQL Server IFI.
is_lpim_enabled bool: SQL Server LPIM.
is_optimize_for_ad_hoc_workloads_enabled bool: SQL Server Optimize for Adhoc workloads.
max_dop int: SQL Server MAXDOP.
max_server_memory_mb int: SQL Server maximum memory.
min_server_memory_mb int: SQL Server minimum memory.

collation String: SQL Server Collation.
isIfiEnabled Boolean: SQL Server IFI.
isLpimEnabled Boolean: SQL Server LPIM.
isOptimizeForAdHocWorkloadsEnabled Boolean: SQL Server Optimize for Adhoc workloads.
maxDop Number: SQL Server MAXDOP.
maxServerMemoryMB Number: SQL Server maximum memory.
minServerMemoryMB Number: SQL Server minimum memory.

SQLStorageSettings, SQLStorageSettingsArgs

DefaultFilePath string: SQL Server default file path
Luns List<int>: Logical Unit Numbers for the disks.

DefaultFilePath string: SQL Server default file path
Luns []int: Logical Unit Numbers for the disks.

defaultFilePath String: SQL Server default file path
luns List<Integer>: Logical Unit Numbers for the disks.

defaultFilePath string: SQL Server default file path
luns number[]: Logical Unit Numbers for the disks.

default_file_path str: SQL Server default file path
luns Sequence[int]: Logical Unit Numbers for the disks.

defaultFilePath String: SQL Server default file path
luns List<Number>: Logical Unit Numbers for the disks.

SQLStorageSettingsResponse, SQLStorageSettingsResponseArgs

DefaultFilePath string: SQL Server default file path
Luns List<int>: Logical Unit Numbers for the disks.

DefaultFilePath string: SQL Server default file path
Luns []int: Logical Unit Numbers for the disks.

defaultFilePath String: SQL Server default file path
luns List<Integer>: Logical Unit Numbers for the disks.

defaultFilePath string: SQL Server default file path
luns number[]: Logical Unit Numbers for the disks.

default_file_path str: SQL Server default file path
luns Sequence[int]: Logical Unit Numbers for the disks.

defaultFilePath String: SQL Server default file path
luns List<Number>: Logical Unit Numbers for the disks.

SQLTempDbSettings, SQLTempDbSettingsArgs

DataFileCount int: SQL Server tempdb data file count
DataFileSize int: SQL Server tempdb data file size
DataGrowth int: SQL Server tempdb data file autoGrowth size
DefaultFilePath string: SQL Server default file path
LogFileSize int: SQL Server tempdb log file size
LogGrowth int: SQL Server tempdb log file autoGrowth size
Luns List<int>: Logical Unit Numbers for the disks.
PersistFolder bool: SQL Server tempdb persist folder choice
PersistFolderPath string: SQL Server tempdb persist folder location

DataFileCount int: SQL Server tempdb data file count
DataFileSize int: SQL Server tempdb data file size
DataGrowth int: SQL Server tempdb data file autoGrowth size
DefaultFilePath string: SQL Server default file path
LogFileSize int: SQL Server tempdb log file size
LogGrowth int: SQL Server tempdb log file autoGrowth size
Luns []int: Logical Unit Numbers for the disks.
PersistFolder bool: SQL Server tempdb persist folder choice
PersistFolderPath string: SQL Server tempdb persist folder location

dataFileCount Integer: SQL Server tempdb data file count
dataFileSize Integer: SQL Server tempdb data file size
dataGrowth Integer: SQL Server tempdb data file autoGrowth size
defaultFilePath String: SQL Server default file path
logFileSize Integer: SQL Server tempdb log file size
logGrowth Integer: SQL Server tempdb log file autoGrowth size
luns List<Integer>: Logical Unit Numbers for the disks.
persistFolder Boolean: SQL Server tempdb persist folder choice
persistFolderPath String: SQL Server tempdb persist folder location

dataFileCount number: SQL Server tempdb data file count
dataFileSize number: SQL Server tempdb data file size
dataGrowth number: SQL Server tempdb data file autoGrowth size
defaultFilePath string: SQL Server default file path
logFileSize number: SQL Server tempdb log file size
logGrowth number: SQL Server tempdb log file autoGrowth size
luns number[]: Logical Unit Numbers for the disks.
persistFolder boolean: SQL Server tempdb persist folder choice
persistFolderPath string: SQL Server tempdb persist folder location

data_file_count int: SQL Server tempdb data file count
data_file_size int: SQL Server tempdb data file size
data_growth int: SQL Server tempdb data file autoGrowth size
default_file_path str: SQL Server default file path
log_file_size int: SQL Server tempdb log file size
log_growth int: SQL Server tempdb log file autoGrowth size
luns Sequence[int]: Logical Unit Numbers for the disks.
persist_folder bool: SQL Server tempdb persist folder choice
persist_folder_path str: SQL Server tempdb persist folder location

dataFileCount Number: SQL Server tempdb data file count
dataFileSize Number: SQL Server tempdb data file size
dataGrowth Number: SQL Server tempdb data file autoGrowth size
defaultFilePath String: SQL Server default file path
logFileSize Number: SQL Server tempdb log file size
logGrowth Number: SQL Server tempdb log file autoGrowth size
luns List<Number>: Logical Unit Numbers for the disks.
persistFolder Boolean: SQL Server tempdb persist folder choice
persistFolderPath String: SQL Server tempdb persist folder location

SQLTempDbSettingsResponse, SQLTempDbSettingsResponseArgs

DataFileCount int: SQL Server tempdb data file count
DataFileSize int: SQL Server tempdb data file size
DataGrowth int: SQL Server tempdb data file autoGrowth size
DefaultFilePath string: SQL Server default file path
LogFileSize int: SQL Server tempdb log file size
LogGrowth int: SQL Server tempdb log file autoGrowth size
Luns List<int>: Logical Unit Numbers for the disks.
PersistFolder bool: SQL Server tempdb persist folder choice
PersistFolderPath string: SQL Server tempdb persist folder location

DataFileCount int: SQL Server tempdb data file count
DataFileSize int: SQL Server tempdb data file size
DataGrowth int: SQL Server tempdb data file autoGrowth size
DefaultFilePath string: SQL Server default file path
LogFileSize int: SQL Server tempdb log file size
LogGrowth int: SQL Server tempdb log file autoGrowth size
Luns []int: Logical Unit Numbers for the disks.
PersistFolder bool: SQL Server tempdb persist folder choice
PersistFolderPath string: SQL Server tempdb persist folder location

dataFileCount Integer: SQL Server tempdb data file count
dataFileSize Integer: SQL Server tempdb data file size
dataGrowth Integer: SQL Server tempdb data file autoGrowth size
defaultFilePath String: SQL Server default file path
logFileSize Integer: SQL Server tempdb log file size
logGrowth Integer: SQL Server tempdb log file autoGrowth size
luns List<Integer>: Logical Unit Numbers for the disks.
persistFolder Boolean: SQL Server tempdb persist folder choice
persistFolderPath String: SQL Server tempdb persist folder location

dataFileCount number: SQL Server tempdb data file count
dataFileSize number: SQL Server tempdb data file size
dataGrowth number: SQL Server tempdb data file autoGrowth size
defaultFilePath string: SQL Server default file path
logFileSize number: SQL Server tempdb log file size
logGrowth number: SQL Server tempdb log file autoGrowth size
luns number[]: Logical Unit Numbers for the disks.
persistFolder boolean: SQL Server tempdb persist folder choice
persistFolderPath string: SQL Server tempdb persist folder location

data_file_count int: SQL Server tempdb data file count
data_file_size int: SQL Server tempdb data file size
data_growth int: SQL Server tempdb data file autoGrowth size
default_file_path str: SQL Server default file path
log_file_size int: SQL Server tempdb log file size
log_growth int: SQL Server tempdb log file autoGrowth size
luns Sequence[int]: Logical Unit Numbers for the disks.
persist_folder bool: SQL Server tempdb persist folder choice
persist_folder_path str: SQL Server tempdb persist folder location

dataFileCount Number: SQL Server tempdb data file count
dataFileSize Number: SQL Server tempdb data file size
dataGrowth Number: SQL Server tempdb data file autoGrowth size
defaultFilePath String: SQL Server default file path
logFileSize Number: SQL Server tempdb log file size
logGrowth Number: SQL Server tempdb log file autoGrowth size
luns List<Number>: Logical Unit Numbers for the disks.
persistFolder Boolean: SQL Server tempdb persist folder choice
persistFolderPath String: SQL Server tempdb persist folder location

Schedule, ScheduleArgs

DayOfWeek Pulumi.AzureNative.SqlVirtualMachine.AssessmentDayOfWeek: Day of the week to run assessment.
Enable bool: Enable or disable assessment schedule on SQL virtual machine.
MonthlyOccurrence int: Occurrence of the DayOfWeek day within a month to schedule assessment. Takes values: 1,2,3,4 and -1. Use -1 for last DayOfWeek day of the month
StartTime string: Time of the day in HH:mm format. Eg. 17:30
WeeklyInterval int: Number of weeks to schedule between 2 assessment runs. Takes value from 1-6

DayOfWeek AssessmentDayOfWeek: Day of the week to run assessment.
Enable bool: Enable or disable assessment schedule on SQL virtual machine.
MonthlyOccurrence int: Occurrence of the DayOfWeek day within a month to schedule assessment. Takes values: 1,2,3,4 and -1. Use -1 for last DayOfWeek day of the month
StartTime string: Time of the day in HH:mm format. Eg. 17:30
WeeklyInterval int: Number of weeks to schedule between 2 assessment runs. Takes value from 1-6

dayOfWeek AssessmentDayOfWeek: Day of the week to run assessment.
enable Boolean: Enable or disable assessment schedule on SQL virtual machine.
monthlyOccurrence Integer: Occurrence of the DayOfWeek day within a month to schedule assessment. Takes values: 1,2,3,4 and -1. Use -1 for last DayOfWeek day of the month
startTime String: Time of the day in HH:mm format. Eg. 17:30
weeklyInterval Integer: Number of weeks to schedule between 2 assessment runs. Takes value from 1-6

dayOfWeek AssessmentDayOfWeek: Day of the week to run assessment.
enable boolean: Enable or disable assessment schedule on SQL virtual machine.
monthlyOccurrence number: Occurrence of the DayOfWeek day within a month to schedule assessment. Takes values: 1,2,3,4 and -1. Use -1 for last DayOfWeek day of the month
startTime string: Time of the day in HH:mm format. Eg. 17:30
weeklyInterval number: Number of weeks to schedule between 2 assessment runs. Takes value from 1-6

day_of_week AssessmentDayOfWeek: Day of the week to run assessment.
enable bool: Enable or disable assessment schedule on SQL virtual machine.
monthly_occurrence int: Occurrence of the DayOfWeek day within a month to schedule assessment. Takes values: 1,2,3,4 and -1. Use -1 for last DayOfWeek day of the month
start_time str: Time of the day in HH:mm format. Eg. 17:30
weekly_interval int: Number of weeks to schedule between 2 assessment runs. Takes value from 1-6

dayOfWeek "Monday" | "Tuesday" | "Wednesday" | "Thursday" | "Friday" | "Saturday" | "Sunday": Day of the week to run assessment.
enable Boolean: Enable or disable assessment schedule on SQL virtual machine.
monthlyOccurrence Number: Occurrence of the DayOfWeek day within a month to schedule assessment. Takes values: 1,2,3,4 and -1. Use -1 for last DayOfWeek day of the month
startTime String: Time of the day in HH:mm format. Eg. 17:30
weeklyInterval Number: Number of weeks to schedule between 2 assessment runs. Takes value from 1-6

ScheduleResponse, ScheduleResponseArgs

DayOfWeek string: Day of the week to run assessment.
Enable bool: Enable or disable assessment schedule on SQL virtual machine.
MonthlyOccurrence int: Occurrence of the DayOfWeek day within a month to schedule assessment. Takes values: 1,2,3,4 and -1. Use -1 for last DayOfWeek day of the month
StartTime string: Time of the day in HH:mm format. Eg. 17:30
WeeklyInterval int: Number of weeks to schedule between 2 assessment runs. Takes value from 1-6

DayOfWeek string: Day of the week to run assessment.
Enable bool: Enable or disable assessment schedule on SQL virtual machine.
MonthlyOccurrence int: Occurrence of the DayOfWeek day within a month to schedule assessment. Takes values: 1,2,3,4 and -1. Use -1 for last DayOfWeek day of the month
StartTime string: Time of the day in HH:mm format. Eg. 17:30
WeeklyInterval int: Number of weeks to schedule between 2 assessment runs. Takes value from 1-6

dayOfWeek String: Day of the week to run assessment.
enable Boolean: Enable or disable assessment schedule on SQL virtual machine.
monthlyOccurrence Integer: Occurrence of the DayOfWeek day within a month to schedule assessment. Takes values: 1,2,3,4 and -1. Use -1 for last DayOfWeek day of the month
startTime String: Time of the day in HH:mm format. Eg. 17:30
weeklyInterval Integer: Number of weeks to schedule between 2 assessment runs. Takes value from 1-6

dayOfWeek string: Day of the week to run assessment.
enable boolean: Enable or disable assessment schedule on SQL virtual machine.
monthlyOccurrence number: Occurrence of the DayOfWeek day within a month to schedule assessment. Takes values: 1,2,3,4 and -1. Use -1 for last DayOfWeek day of the month
startTime string: Time of the day in HH:mm format. Eg. 17:30
weeklyInterval number: Number of weeks to schedule between 2 assessment runs. Takes value from 1-6

day_of_week str: Day of the week to run assessment.
enable bool: Enable or disable assessment schedule on SQL virtual machine.
monthly_occurrence int: Occurrence of the DayOfWeek day within a month to schedule assessment. Takes values: 1,2,3,4 and -1. Use -1 for last DayOfWeek day of the month
start_time str: Time of the day in HH:mm format. Eg. 17:30
weekly_interval int: Number of weeks to schedule between 2 assessment runs. Takes value from 1-6

dayOfWeek String: Day of the week to run assessment.
enable Boolean: Enable or disable assessment schedule on SQL virtual machine.
monthlyOccurrence Number: Occurrence of the DayOfWeek day within a month to schedule assessment. Takes values: 1,2,3,4 and -1. Use -1 for last DayOfWeek day of the month
startTime String: Time of the day in HH:mm format. Eg. 17:30
weeklyInterval Number: Number of weeks to schedule between 2 assessment runs. Takes value from 1-6

ServerConfigurationsManagementSettings, ServerConfigurationsManagementSettingsArgs

AdditionalFeaturesServerConfigurations Pulumi.AzureNative.SqlVirtualMachine.Inputs.AdditionalFeaturesServerConfigurations: Additional SQL feature settings.
SqlConnectivityUpdateSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.SqlConnectivityUpdateSettings: SQL connectivity type settings.
SqlInstanceSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.SQLInstanceSettings: SQL Instance settings.
SqlStorageUpdateSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.SqlStorageUpdateSettings: SQL storage update settings.
SqlWorkloadTypeUpdateSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.SqlWorkloadTypeUpdateSettings: SQL workload type settings.

AdditionalFeaturesServerConfigurations AdditionalFeaturesServerConfigurations: Additional SQL feature settings.
SqlConnectivityUpdateSettings SqlConnectivityUpdateSettings: SQL connectivity type settings.
SqlInstanceSettings SQLInstanceSettings: SQL Instance settings.
SqlStorageUpdateSettings SqlStorageUpdateSettings: SQL storage update settings.
SqlWorkloadTypeUpdateSettings SqlWorkloadTypeUpdateSettings: SQL workload type settings.

additionalFeaturesServerConfigurations AdditionalFeaturesServerConfigurations: Additional SQL feature settings.
sqlConnectivityUpdateSettings SqlConnectivityUpdateSettings: SQL connectivity type settings.
sqlInstanceSettings SQLInstanceSettings: SQL Instance settings.
sqlStorageUpdateSettings SqlStorageUpdateSettings: SQL storage update settings.
sqlWorkloadTypeUpdateSettings SqlWorkloadTypeUpdateSettings: SQL workload type settings.

additionalFeaturesServerConfigurations AdditionalFeaturesServerConfigurations: Additional SQL feature settings.
sqlConnectivityUpdateSettings SqlConnectivityUpdateSettings: SQL connectivity type settings.
sqlInstanceSettings SQLInstanceSettings: SQL Instance settings.
sqlStorageUpdateSettings SqlStorageUpdateSettings: SQL storage update settings.
sqlWorkloadTypeUpdateSettings SqlWorkloadTypeUpdateSettings: SQL workload type settings.

additional_features_server_configurations AdditionalFeaturesServerConfigurations: Additional SQL feature settings.
sql_connectivity_update_settings SqlConnectivityUpdateSettings: SQL connectivity type settings.
sql_instance_settings SQLInstanceSettings: SQL Instance settings.
sql_storage_update_settings SqlStorageUpdateSettings: SQL storage update settings.
sql_workload_type_update_settings SqlWorkloadTypeUpdateSettings: SQL workload type settings.

additionalFeaturesServerConfigurations Property Map: Additional SQL feature settings.
sqlConnectivityUpdateSettings Property Map: SQL connectivity type settings.
sqlInstanceSettings Property Map: SQL Instance settings.
sqlStorageUpdateSettings Property Map: SQL storage update settings.
sqlWorkloadTypeUpdateSettings Property Map: SQL workload type settings.

ServerConfigurationsManagementSettingsResponse, ServerConfigurationsManagementSettingsResponseArgs

AdditionalFeaturesServerConfigurations Pulumi.AzureNative.SqlVirtualMachine.Inputs.AdditionalFeaturesServerConfigurationsResponse: Additional SQL feature settings.
SqlConnectivityUpdateSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.SqlConnectivityUpdateSettingsResponse: SQL connectivity type settings.
SqlInstanceSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.SQLInstanceSettingsResponse: SQL Instance settings.
SqlStorageUpdateSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.SqlStorageUpdateSettingsResponse: SQL storage update settings.
SqlWorkloadTypeUpdateSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.SqlWorkloadTypeUpdateSettingsResponse: SQL workload type settings.

AdditionalFeaturesServerConfigurations AdditionalFeaturesServerConfigurationsResponse: Additional SQL feature settings.
SqlConnectivityUpdateSettings SqlConnectivityUpdateSettingsResponse: SQL connectivity type settings.
SqlInstanceSettings SQLInstanceSettingsResponse: SQL Instance settings.
SqlStorageUpdateSettings SqlStorageUpdateSettingsResponse: SQL storage update settings.
SqlWorkloadTypeUpdateSettings SqlWorkloadTypeUpdateSettingsResponse: SQL workload type settings.

additionalFeaturesServerConfigurations AdditionalFeaturesServerConfigurationsResponse: Additional SQL feature settings.
sqlConnectivityUpdateSettings SqlConnectivityUpdateSettingsResponse: SQL connectivity type settings.
sqlInstanceSettings SQLInstanceSettingsResponse: SQL Instance settings.
sqlStorageUpdateSettings SqlStorageUpdateSettingsResponse: SQL storage update settings.
sqlWorkloadTypeUpdateSettings SqlWorkloadTypeUpdateSettingsResponse: SQL workload type settings.

additionalFeaturesServerConfigurations AdditionalFeaturesServerConfigurationsResponse: Additional SQL feature settings.
sqlConnectivityUpdateSettings SqlConnectivityUpdateSettingsResponse: SQL connectivity type settings.
sqlInstanceSettings SQLInstanceSettingsResponse: SQL Instance settings.
sqlStorageUpdateSettings SqlStorageUpdateSettingsResponse: SQL storage update settings.
sqlWorkloadTypeUpdateSettings SqlWorkloadTypeUpdateSettingsResponse: SQL workload type settings.

additional_features_server_configurations AdditionalFeaturesServerConfigurationsResponse: Additional SQL feature settings.
sql_connectivity_update_settings SqlConnectivityUpdateSettingsResponse: SQL connectivity type settings.
sql_instance_settings SQLInstanceSettingsResponse: SQL Instance settings.
sql_storage_update_settings SqlStorageUpdateSettingsResponse: SQL storage update settings.
sql_workload_type_update_settings SqlWorkloadTypeUpdateSettingsResponse: SQL workload type settings.

additionalFeaturesServerConfigurations Property Map: Additional SQL feature settings.
sqlConnectivityUpdateSettings Property Map: SQL connectivity type settings.
sqlInstanceSettings Property Map: SQL Instance settings.
sqlStorageUpdateSettings Property Map: SQL storage update settings.
sqlWorkloadTypeUpdateSettings Property Map: SQL workload type settings.

SqlConnectivityUpdateSettings, SqlConnectivityUpdateSettingsArgs

ConnectivityType string | Pulumi.AzureNative.SqlVirtualMachine.ConnectivityType: SQL Server connectivity option.
Port int: SQL Server port.
SqlAuthUpdatePassword string: SQL Server sysadmin login password.
SqlAuthUpdateUserName string: SQL Server sysadmin login to create.

ConnectivityType string | ConnectivityType: SQL Server connectivity option.
Port int: SQL Server port.
SqlAuthUpdatePassword string: SQL Server sysadmin login password.
SqlAuthUpdateUserName string: SQL Server sysadmin login to create.

connectivityType String | ConnectivityType: SQL Server connectivity option.
port Integer: SQL Server port.
sqlAuthUpdatePassword String: SQL Server sysadmin login password.
sqlAuthUpdateUserName String: SQL Server sysadmin login to create.

connectivityType string | ConnectivityType: SQL Server connectivity option.
port number: SQL Server port.
sqlAuthUpdatePassword string: SQL Server sysadmin login password.
sqlAuthUpdateUserName string: SQL Server sysadmin login to create.

connectivity_type str | ConnectivityType: SQL Server connectivity option.
port int: SQL Server port.
sql_auth_update_password str: SQL Server sysadmin login password.
sql_auth_update_user_name str: SQL Server sysadmin login to create.

connectivityType String | "LOCAL" | "PRIVATE" | "PUBLIC": SQL Server connectivity option.
port Number: SQL Server port.
sqlAuthUpdatePassword String: SQL Server sysadmin login password.
sqlAuthUpdateUserName String: SQL Server sysadmin login to create.

SqlConnectivityUpdateSettingsResponse, SqlConnectivityUpdateSettingsResponseArgs

ConnectivityType string: SQL Server connectivity option.
Port int: SQL Server port.

ConnectivityType string: SQL Server connectivity option.
Port int: SQL Server port.

connectivityType String: SQL Server connectivity option.
port Integer: SQL Server port.

connectivityType string: SQL Server connectivity option.
port number: SQL Server port.

connectivity_type str: SQL Server connectivity option.
port int: SQL Server port.

connectivityType String: SQL Server connectivity option.
port Number: SQL Server port.

SqlImageSku, SqlImageSkuArgs

Developer: Developer
Express: Express
Standard: Standard
Enterprise: Enterprise
Web: Web

SqlImageSkuDeveloper: Developer
SqlImageSkuExpress: Express
SqlImageSkuStandard: Standard
SqlImageSkuEnterprise: Enterprise
SqlImageSkuWeb: Web

Developer: Developer
Express: Express
Standard: Standard
Enterprise: Enterprise
Web: Web

Developer: Developer
Express: Express
Standard: Standard
Enterprise: Enterprise
Web: Web

DEVELOPER: Developer
EXPRESS: Express
STANDARD: Standard
ENTERPRISE: Enterprise
WEB: Web

"Developer": Developer
"Express": Express
"Standard": Standard
"Enterprise": Enterprise
"Web": Web

SqlManagementMode, SqlManagementModeArgs

Full: Full
LightWeight: LightWeight
NoAgent: NoAgent

SqlManagementModeFull: Full
SqlManagementModeLightWeight: LightWeight
SqlManagementModeNoAgent: NoAgent

Full: Full
LightWeight: LightWeight
NoAgent: NoAgent

Full: Full
LightWeight: LightWeight
NoAgent: NoAgent

FULL: Full
LIGHT_WEIGHT: LightWeight
NO_AGENT: NoAgent

"Full": Full
"LightWeight": LightWeight
"NoAgent": NoAgent

SqlServerLicenseType, SqlServerLicenseTypeArgs

PAYG: PAYG
AHUB: AHUB
DR: DR

SqlServerLicenseTypePAYG: PAYG
SqlServerLicenseTypeAHUB: AHUB
SqlServerLicenseTypeDR: DR

PAYG: PAYG
AHUB: AHUB
DR: DR

PAYG: PAYG
AHUB: AHUB
DR: DR

PAYG: PAYG
AHUB: AHUB
DR: DR

"PAYG": PAYG
"AHUB": AHUB
"DR": DR

SqlStorageUpdateSettings, SqlStorageUpdateSettingsArgs

DiskConfigurationType string | Pulumi.AzureNative.SqlVirtualMachine.DiskConfigurationType: Disk configuration to apply to SQL Server.
DiskCount int: Virtual machine disk count.
StartingDeviceId int: Device id of the first disk to be updated.

DiskConfigurationType string | DiskConfigurationType: Disk configuration to apply to SQL Server.
DiskCount int: Virtual machine disk count.
StartingDeviceId int: Device id of the first disk to be updated.

diskConfigurationType String | DiskConfigurationType: Disk configuration to apply to SQL Server.
diskCount Integer: Virtual machine disk count.
startingDeviceId Integer: Device id of the first disk to be updated.

diskConfigurationType string | DiskConfigurationType: Disk configuration to apply to SQL Server.
diskCount number: Virtual machine disk count.
startingDeviceId number: Device id of the first disk to be updated.

disk_configuration_type str | DiskConfigurationType: Disk configuration to apply to SQL Server.
disk_count int: Virtual machine disk count.
starting_device_id int: Device id of the first disk to be updated.

diskConfigurationType String | "NEW" | "EXTEND" | "ADD": Disk configuration to apply to SQL Server.
diskCount Number: Virtual machine disk count.
startingDeviceId Number: Device id of the first disk to be updated.

SqlStorageUpdateSettingsResponse, SqlStorageUpdateSettingsResponseArgs

DiskConfigurationType string: Disk configuration to apply to SQL Server.
DiskCount int: Virtual machine disk count.
StartingDeviceId int: Device id of the first disk to be updated.

DiskConfigurationType string: Disk configuration to apply to SQL Server.
DiskCount int: Virtual machine disk count.
StartingDeviceId int: Device id of the first disk to be updated.

diskConfigurationType String: Disk configuration to apply to SQL Server.
diskCount Integer: Virtual machine disk count.
startingDeviceId Integer: Device id of the first disk to be updated.

diskConfigurationType string: Disk configuration to apply to SQL Server.
diskCount number: Virtual machine disk count.
startingDeviceId number: Device id of the first disk to be updated.

disk_configuration_type str: Disk configuration to apply to SQL Server.
disk_count int: Virtual machine disk count.
starting_device_id int: Device id of the first disk to be updated.

diskConfigurationType String: Disk configuration to apply to SQL Server.
diskCount Number: Virtual machine disk count.
startingDeviceId Number: Device id of the first disk to be updated.

SqlWorkloadType, SqlWorkloadTypeArgs

GENERAL: GENERAL
OLTP: OLTP
DW: DW

SqlWorkloadTypeGENERAL: GENERAL
SqlWorkloadTypeOLTP: OLTP
SqlWorkloadTypeDW: DW

GENERAL: GENERAL
OLTP: OLTP
DW: DW

GENERAL: GENERAL
OLTP: OLTP
DW: DW

GENERAL: GENERAL
OLTP: OLTP
DW: DW

"GENERAL": GENERAL
"OLTP": OLTP
"DW": DW

SqlWorkloadTypeUpdateSettings, SqlWorkloadTypeUpdateSettingsArgs

SqlWorkloadType string | Pulumi.AzureNative.SqlVirtualMachine.SqlWorkloadType: SQL Server workload type.

SqlWorkloadType string | SqlWorkloadType: SQL Server workload type.

sqlWorkloadType String | SqlWorkloadType: SQL Server workload type.

sqlWorkloadType string | SqlWorkloadType: SQL Server workload type.

sql_workload_type str | SqlWorkloadType: SQL Server workload type.

sqlWorkloadType String | "GENERAL" | "OLTP" | "DW": SQL Server workload type.

SqlWorkloadTypeUpdateSettingsResponse, SqlWorkloadTypeUpdateSettingsResponseArgs

SqlWorkloadType string: SQL Server workload type.

SqlWorkloadType string: SQL Server workload type.

sqlWorkloadType String: SQL Server workload type.

sqlWorkloadType string: SQL Server workload type.

sql_workload_type str: SQL Server workload type.

sqlWorkloadType String: SQL Server workload type.

StorageConfigurationSettings, StorageConfigurationSettingsArgs

DiskConfigurationType string | Pulumi.AzureNative.SqlVirtualMachine.DiskConfigurationType: Disk configuration to apply to SQL Server.
SqlDataSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.SQLStorageSettings: SQL Server Data Storage Settings.
SqlLogSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.SQLStorageSettings: SQL Server Log Storage Settings.
SqlSystemDbOnDataDisk bool: SQL Server SystemDb Storage on DataPool if true.
SqlTempDbSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.SQLTempDbSettings: SQL Server TempDb Storage Settings.
StorageWorkloadType string | Pulumi.AzureNative.SqlVirtualMachine.StorageWorkloadType: Storage workload type.

DiskConfigurationType string | DiskConfigurationType: Disk configuration to apply to SQL Server.
SqlDataSettings SQLStorageSettings: SQL Server Data Storage Settings.
SqlLogSettings SQLStorageSettings: SQL Server Log Storage Settings.
SqlSystemDbOnDataDisk bool: SQL Server SystemDb Storage on DataPool if true.
SqlTempDbSettings SQLTempDbSettings: SQL Server TempDb Storage Settings.
StorageWorkloadType string | StorageWorkloadType: Storage workload type.

diskConfigurationType String | DiskConfigurationType: Disk configuration to apply to SQL Server.
sqlDataSettings SQLStorageSettings: SQL Server Data Storage Settings.
sqlLogSettings SQLStorageSettings: SQL Server Log Storage Settings.
sqlSystemDbOnDataDisk Boolean: SQL Server SystemDb Storage on DataPool if true.
sqlTempDbSettings SQLTempDbSettings: SQL Server TempDb Storage Settings.
storageWorkloadType String | StorageWorkloadType: Storage workload type.

diskConfigurationType string | DiskConfigurationType: Disk configuration to apply to SQL Server.
sqlDataSettings SQLStorageSettings: SQL Server Data Storage Settings.
sqlLogSettings SQLStorageSettings: SQL Server Log Storage Settings.
sqlSystemDbOnDataDisk boolean: SQL Server SystemDb Storage on DataPool if true.
sqlTempDbSettings SQLTempDbSettings: SQL Server TempDb Storage Settings.
storageWorkloadType string | StorageWorkloadType: Storage workload type.

disk_configuration_type str | DiskConfigurationType: Disk configuration to apply to SQL Server.
sql_data_settings SQLStorageSettings: SQL Server Data Storage Settings.
sql_log_settings SQLStorageSettings: SQL Server Log Storage Settings.
sql_system_db_on_data_disk bool: SQL Server SystemDb Storage on DataPool if true.
sql_temp_db_settings SQLTempDbSettings: SQL Server TempDb Storage Settings.
storage_workload_type str | StorageWorkloadType: Storage workload type.

diskConfigurationType String | "NEW" | "EXTEND" | "ADD": Disk configuration to apply to SQL Server.
sqlDataSettings Property Map: SQL Server Data Storage Settings.
sqlLogSettings Property Map: SQL Server Log Storage Settings.
sqlSystemDbOnDataDisk Boolean: SQL Server SystemDb Storage on DataPool if true.
sqlTempDbSettings Property Map: SQL Server TempDb Storage Settings.
storageWorkloadType String | "GENERAL" | "OLTP" | "DW": Storage workload type.

StorageConfigurationSettingsResponse, StorageConfigurationSettingsResponseArgs

DiskConfigurationType string: Disk configuration to apply to SQL Server.
SqlDataSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.SQLStorageSettingsResponse: SQL Server Data Storage Settings.
SqlLogSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.SQLStorageSettingsResponse: SQL Server Log Storage Settings.
SqlSystemDbOnDataDisk bool: SQL Server SystemDb Storage on DataPool if true.
SqlTempDbSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.SQLTempDbSettingsResponse: SQL Server TempDb Storage Settings.
StorageWorkloadType string: Storage workload type.

DiskConfigurationType string: Disk configuration to apply to SQL Server.
SqlDataSettings SQLStorageSettingsResponse: SQL Server Data Storage Settings.
SqlLogSettings SQLStorageSettingsResponse: SQL Server Log Storage Settings.
SqlSystemDbOnDataDisk bool: SQL Server SystemDb Storage on DataPool if true.
SqlTempDbSettings SQLTempDbSettingsResponse: SQL Server TempDb Storage Settings.
StorageWorkloadType string: Storage workload type.

diskConfigurationType String: Disk configuration to apply to SQL Server.
sqlDataSettings SQLStorageSettingsResponse: SQL Server Data Storage Settings.
sqlLogSettings SQLStorageSettingsResponse: SQL Server Log Storage Settings.
sqlSystemDbOnDataDisk Boolean: SQL Server SystemDb Storage on DataPool if true.
sqlTempDbSettings SQLTempDbSettingsResponse: SQL Server TempDb Storage Settings.
storageWorkloadType String: Storage workload type.

diskConfigurationType string: Disk configuration to apply to SQL Server.
sqlDataSettings SQLStorageSettingsResponse: SQL Server Data Storage Settings.
sqlLogSettings SQLStorageSettingsResponse: SQL Server Log Storage Settings.
sqlSystemDbOnDataDisk boolean: SQL Server SystemDb Storage on DataPool if true.
sqlTempDbSettings SQLTempDbSettingsResponse: SQL Server TempDb Storage Settings.
storageWorkloadType string: Storage workload type.

disk_configuration_type str: Disk configuration to apply to SQL Server.
sql_data_settings SQLStorageSettingsResponse: SQL Server Data Storage Settings.
sql_log_settings SQLStorageSettingsResponse: SQL Server Log Storage Settings.
sql_system_db_on_data_disk bool: SQL Server SystemDb Storage on DataPool if true.
sql_temp_db_settings SQLTempDbSettingsResponse: SQL Server TempDb Storage Settings.
storage_workload_type str: Storage workload type.

diskConfigurationType String: Disk configuration to apply to SQL Server.
sqlDataSettings Property Map: SQL Server Data Storage Settings.
sqlLogSettings Property Map: SQL Server Log Storage Settings.
sqlSystemDbOnDataDisk Boolean: SQL Server SystemDb Storage on DataPool if true.
sqlTempDbSettings Property Map: SQL Server TempDb Storage Settings.
storageWorkloadType String: Storage workload type.

StorageWorkloadType, StorageWorkloadTypeArgs

GENERAL: GENERAL
OLTP: OLTP
DW: DW

StorageWorkloadTypeGENERAL: GENERAL
StorageWorkloadTypeOLTP: OLTP
StorageWorkloadTypeDW: DW

GENERAL: GENERAL
OLTP: OLTP
DW: DW

GENERAL: GENERAL
OLTP: OLTP
DW: DW

GENERAL: GENERAL
OLTP: OLTP
DW: DW

"GENERAL": GENERAL
"OLTP": OLTP
"DW": DW

SystemDataResponse, SystemDataResponseArgs

CreatedAt string: The timestamp of resource creation (UTC).
CreatedBy string: The identity that created the resource.
CreatedByType string: The type of identity that created the resource.
LastModifiedAt string: The timestamp of resource last modification (UTC)
LastModifiedBy string: The identity that last modified the resource.
LastModifiedByType string: The type of identity that last modified the resource.

CreatedAt string: The timestamp of resource creation (UTC).
CreatedBy string: The identity that created the resource.
CreatedByType string: The type of identity that created the resource.
LastModifiedAt string: The timestamp of resource last modification (UTC)
LastModifiedBy string: The identity that last modified the resource.
LastModifiedByType string: The type of identity that last modified the resource.

createdAt String: The timestamp of resource creation (UTC).
createdBy String: The identity that created the resource.
createdByType String: The type of identity that created the resource.
lastModifiedAt String: The timestamp of resource last modification (UTC)
lastModifiedBy String: The identity that last modified the resource.
lastModifiedByType String: The type of identity that last modified the resource.

createdAt string: The timestamp of resource creation (UTC).
createdBy string: The identity that created the resource.
createdByType string: The type of identity that created the resource.
lastModifiedAt string: The timestamp of resource last modification (UTC)
lastModifiedBy string: The identity that last modified the resource.
lastModifiedByType string: The type of identity that last modified the resource.

created_at str: The timestamp of resource creation (UTC).
created_by str: The identity that created the resource.
created_by_type str: The type of identity that created the resource.
last_modified_at str: The timestamp of resource last modification (UTC)
last_modified_by str: The identity that last modified the resource.
last_modified_by_type str: The type of identity that last modified the resource.

createdAt String: The timestamp of resource creation (UTC).
createdBy String: The identity that created the resource.
createdByType String: The type of identity that created the resource.
lastModifiedAt String: The timestamp of resource last modification (UTC)
lastModifiedBy String: The identity that last modified the resource.
lastModifiedByType String: The type of identity that last modified the resource.

WsfcDomainCredentials, WsfcDomainCredentialsArgs

ClusterBootstrapAccountPassword string: Cluster bootstrap account password.
ClusterOperatorAccountPassword string: Cluster operator account password.
SqlServiceAccountPassword string: SQL service account password.

ClusterBootstrapAccountPassword string: Cluster bootstrap account password.
ClusterOperatorAccountPassword string: Cluster operator account password.
SqlServiceAccountPassword string: SQL service account password.

clusterBootstrapAccountPassword String: Cluster bootstrap account password.
clusterOperatorAccountPassword String: Cluster operator account password.
sqlServiceAccountPassword String: SQL service account password.

clusterBootstrapAccountPassword string: Cluster bootstrap account password.
clusterOperatorAccountPassword string: Cluster operator account password.
sqlServiceAccountPassword string: SQL service account password.

cluster_bootstrap_account_password str: Cluster bootstrap account password.
cluster_operator_account_password str: Cluster operator account password.
sql_service_account_password str: SQL service account password.

clusterBootstrapAccountPassword String: Cluster bootstrap account password.
clusterOperatorAccountPassword String: Cluster operator account password.
sqlServiceAccountPassword String: SQL service account password.

WsfcDomainCredentialsResponse, WsfcDomainCredentialsResponseArgs

ClusterBootstrapAccountPassword string: Cluster bootstrap account password.
ClusterOperatorAccountPassword string: Cluster operator account password.
SqlServiceAccountPassword string: SQL service account password.

ClusterBootstrapAccountPassword string: Cluster bootstrap account password.
ClusterOperatorAccountPassword string: Cluster operator account password.
SqlServiceAccountPassword string: SQL service account password.

clusterBootstrapAccountPassword String: Cluster bootstrap account password.
clusterOperatorAccountPassword String: Cluster operator account password.
sqlServiceAccountPassword String: SQL service account password.

clusterBootstrapAccountPassword string: Cluster bootstrap account password.
clusterOperatorAccountPassword string: Cluster operator account password.
sqlServiceAccountPassword string: SQL service account password.

cluster_bootstrap_account_password str: Cluster bootstrap account password.
cluster_operator_account_password str: Cluster operator account password.
sql_service_account_password str: SQL service account password.

clusterBootstrapAccountPassword String: Cluster bootstrap account password.
clusterOperatorAccountPassword String: Cluster operator account password.
sqlServiceAccountPassword String: SQL service account password.

Import

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

$ pulumi import azure-native:sqlvirtualmachine:SqlVirtualMachine testvm /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachines/{sqlVirtualMachineName}

Package Details

Repository: Azure Native pulumi/pulumi-azure-native
License: Apache-2.0

This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.

Azure Native v2.20.0 published on Wednesday, Nov 29, 2023 by Pulumi

pulumi/pulumi-azure-native

azure-native.sqlvirtualmachine.SqlVirtualMachine

On this page

On this page

Example Usage

Creates or updates a SQL virtual machine and joins it to a SQL virtual machine group.

Creates or updates a SQL virtual machine for Automated Back up Settings with Weekly and Days of the week to run the back up.

Creates or updates a SQL virtual machine for Storage Configuration Settings to EXTEND Data, Log or TempDB storage pool.

Creates or updates a SQL virtual machine for Storage Configuration Settings to NEW Data, Log and TempDB storage pool.

Creates or updates a SQL virtual machine with max parameters.

Creates or updates a SQL virtual machine with min parameters.

Create SqlVirtualMachine Resource

SqlVirtualMachine Resource Properties

Inputs

Outputs

Supporting Types

AdditionalFeaturesServerConfigurations, AdditionalFeaturesServerConfigurationsArgs

AdditionalFeaturesServerConfigurationsResponse, AdditionalFeaturesServerConfigurationsResponseArgs

AssessmentDayOfWeek, AssessmentDayOfWeekArgs

AssessmentSettings, AssessmentSettingsArgs

AssessmentSettingsResponse, AssessmentSettingsResponseArgs

AutoBackupDaysOfWeek, AutoBackupDaysOfWeekArgs

AutoBackupSettings, AutoBackupSettingsArgs

AutoBackupSettingsResponse, AutoBackupSettingsResponseArgs

AutoPatchingSettings, AutoPatchingSettingsArgs

AutoPatchingSettingsResponse, AutoPatchingSettingsResponseArgs

BackupScheduleType, BackupScheduleTypeArgs

ConnectivityType, ConnectivityTypeArgs

DayOfWeek, DayOfWeekArgs

DiskConfigurationType, DiskConfigurationTypeArgs

FullBackupFrequencyType, FullBackupFrequencyTypeArgs

IdentityType, IdentityTypeArgs

KeyVaultCredentialSettings, KeyVaultCredentialSettingsArgs

KeyVaultCredentialSettingsResponse, KeyVaultCredentialSettingsResponseArgs

ResourceIdentity, ResourceIdentityArgs

ResourceIdentityResponse, ResourceIdentityResponseArgs

SQLInstanceSettings, SQLInstanceSettingsArgs

SQLInstanceSettingsResponse, SQLInstanceSettingsResponseArgs

SQLStorageSettings, SQLStorageSettingsArgs

SQLStorageSettingsResponse, SQLStorageSettingsResponseArgs

SQLTempDbSettings, SQLTempDbSettingsArgs

SQLTempDbSettingsResponse, SQLTempDbSettingsResponseArgs

Schedule, ScheduleArgs

ScheduleResponse, ScheduleResponseArgs

ServerConfigurationsManagementSettings, ServerConfigurationsManagementSettingsArgs

ServerConfigurationsManagementSettingsResponse, ServerConfigurationsManagementSettingsResponseArgs

SqlConnectivityUpdateSettings, SqlConnectivityUpdateSettingsArgs

SqlConnectivityUpdateSettingsResponse, SqlConnectivityUpdateSettingsResponseArgs

SqlImageSku, SqlImageSkuArgs

SqlManagementMode, SqlManagementModeArgs

SqlServerLicenseType, SqlServerLicenseTypeArgs

SqlStorageUpdateSettings, SqlStorageUpdateSettingsArgs

SqlStorageUpdateSettingsResponse, SqlStorageUpdateSettingsResponseArgs

SqlWorkloadType, SqlWorkloadTypeArgs

SqlWorkloadTypeUpdateSettings, SqlWorkloadTypeUpdateSettingsArgs

SqlWorkloadTypeUpdateSettingsResponse, SqlWorkloadTypeUpdateSettingsResponseArgs

StorageConfigurationSettings, StorageConfigurationSettingsArgs

StorageConfigurationSettingsResponse, StorageConfigurationSettingsResponseArgs

StorageWorkloadType, StorageWorkloadTypeArgs

SystemDataResponse, SystemDataResponseArgs

WsfcDomainCredentials, WsfcDomainCredentialsArgs

WsfcDomainCredentialsResponse, WsfcDomainCredentialsResponseArgs

Import

Package Details

On this page

On this page