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.20.0 published on Wednesday, Nov 29, 2023 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.20.0 published on Wednesday, Nov 29, 2023 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.20.0 published on Wednesday, Nov 29, 2023 by Pulumi