1. Packages
  2. Azure Native
  3. API Docs
  4. sqlvirtualmachine
  5. SqlVirtualMachine
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.29.0 published on Friday, Feb 16, 2024 by Pulumi

azure-native.sqlvirtualmachine.SqlVirtualMachine

Explore with Pulumi AI

azure-native logo
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.29.0 published on Friday, Feb 16, 2024 by Pulumi

    A SQL virtual machine. Azure REST API version: 2022-02-01. Prior API version in Azure Native 1.x: 2017-03-01-preview.

    Other available API versions: 2023-01-01-preview.

    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 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 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 | 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 | 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
    azure-native logo
    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.29.0 published on Friday, Feb 16, 2024 by Pulumi