Docs Home
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.64.2 published on Tuesday, Oct 1, 2024 by Pulumi
azure-native.sqlvirtualmachine.SqlVirtualMachine
Explore with Pulumi AI
This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.
Azure Native v2.64.2 published on Tuesday, Oct 1, 2024 by Pulumi
A SQL virtual machine. Azure REST API version: 2022-02-01. Prior API version in Azure Native 1.x: 2017-03-01-preview.
Other available API versions: 2023-01-01-preview, 2023-10-01.
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 (
sqlvirtualmachine "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 com.pulumi.azurenative.sqlvirtualmachine.inputs.WsfcDomainCredentialsArgs;
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(WsfcDomainCredentialsArgs.builder()
.clusterBootstrapAccountPassword("<Password>")
.clusterOperatorAccountPassword("<Password>")
.sqlServiceAccountPassword("<Password>")
.build())
.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={
"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 = AzureNative.SqlVirtualMachine.BackupScheduleType.Manual,
BackupSystemDbs = true,
DaysOfWeek = new[]
{
AzureNative.SqlVirtualMachine.AutoBackupDaysOfWeek.Monday,
AzureNative.SqlVirtualMachine.AutoBackupDaysOfWeek.Friday,
},
Enable = true,
EnableEncryption = true,
FullBackupFrequency = AzureNative.SqlVirtualMachine.FullBackupFrequencyType.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 = AzureNative.SqlVirtualMachine.ConnectivityType.PRIVATE,
Port = 1433,
SqlAuthUpdatePassword = "<password>",
SqlAuthUpdateUserName = "sqllogin",
},
SqlStorageUpdateSettings = new AzureNative.SqlVirtualMachine.Inputs.SqlStorageUpdateSettingsArgs
{
DiskConfigurationType = AzureNative.SqlVirtualMachine.DiskConfigurationType.NEW,
DiskCount = 1,
StartingDeviceId = 2,
},
SqlWorkloadTypeUpdateSettings = new AzureNative.SqlVirtualMachine.Inputs.SqlWorkloadTypeUpdateSettingsArgs
{
SqlWorkloadType = AzureNative.SqlVirtualMachine.SqlWorkloadType.OLTP,
},
},
SqlImageSku = AzureNative.SqlVirtualMachine.SqlImageSku.Enterprise,
SqlManagement = AzureNative.SqlVirtualMachine.SqlManagementMode.Full,
SqlServerLicenseType = AzureNative.SqlVirtualMachine.SqlServerLicenseType.PAYG,
SqlVirtualMachineName = "testvm",
VirtualMachineResourceId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm",
});
});
package main
import (
sqlvirtualmachine "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(sqlvirtualmachine.BackupScheduleTypeManual),
BackupSystemDbs: pulumi.Bool(true),
DaysOfWeek: pulumi.StringArray{
pulumi.String(sqlvirtualmachine.AutoBackupDaysOfWeekMonday),
pulumi.String(sqlvirtualmachine.AutoBackupDaysOfWeekFriday),
},
Enable: pulumi.Bool(true),
EnableEncryption: pulumi.Bool(true),
FullBackupFrequency: pulumi.String(sqlvirtualmachine.FullBackupFrequencyTypeWeekly),
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.ServerConfigurationsManagementSettingsArgs{
AdditionalFeaturesServerConfigurations: &sqlvirtualmachine.AdditionalFeaturesServerConfigurationsArgs{
IsRServicesEnabled: pulumi.Bool(false),
},
SqlConnectivityUpdateSettings: &sqlvirtualmachine.SqlConnectivityUpdateSettingsArgs{
ConnectivityType: pulumi.String(sqlvirtualmachine.ConnectivityTypePRIVATE),
Port: pulumi.Int(1433),
SqlAuthUpdatePassword: pulumi.String("<password>"),
SqlAuthUpdateUserName: pulumi.String("sqllogin"),
},
SqlStorageUpdateSettings: &sqlvirtualmachine.SqlStorageUpdateSettingsArgs{
DiskConfigurationType: pulumi.String(sqlvirtualmachine.DiskConfigurationTypeNEW),
DiskCount: pulumi.Int(1),
StartingDeviceId: pulumi.Int(2),
},
SqlWorkloadTypeUpdateSettings: &sqlvirtualmachine.SqlWorkloadTypeUpdateSettingsArgs{
SqlWorkloadType: pulumi.String(sqlvirtualmachine.SqlWorkloadTypeOLTP),
},
},
SqlImageSku: pulumi.String(sqlvirtualmachine.SqlImageSkuEnterprise),
SqlManagement: pulumi.String(sqlvirtualmachine.SqlManagementModeFull),
SqlServerLicenseType: pulumi.String(sqlvirtualmachine.SqlServerLicenseTypePAYG),
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 com.pulumi.azurenative.sqlvirtualmachine.inputs.AutoBackupSettingsArgs;
import com.pulumi.azurenative.sqlvirtualmachine.inputs.AutoPatchingSettingsArgs;
import com.pulumi.azurenative.sqlvirtualmachine.inputs.KeyVaultCredentialSettingsArgs;
import com.pulumi.azurenative.sqlvirtualmachine.inputs.ServerConfigurationsManagementSettingsArgs;
import com.pulumi.azurenative.sqlvirtualmachine.inputs.AdditionalFeaturesServerConfigurationsArgs;
import com.pulumi.azurenative.sqlvirtualmachine.inputs.SqlConnectivityUpdateSettingsArgs;
import com.pulumi.azurenative.sqlvirtualmachine.inputs.SqlStorageUpdateSettingsArgs;
import com.pulumi.azurenative.sqlvirtualmachine.inputs.SqlWorkloadTypeUpdateSettingsArgs;
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(AutoBackupSettingsArgs.builder()
.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")
.build())
.autoPatchingSettings(AutoPatchingSettingsArgs.builder()
.dayOfWeek("Sunday")
.enable(true)
.maintenanceWindowDuration(60)
.maintenanceWindowStartingHour(2)
.build())
.keyVaultCredentialSettings(KeyVaultCredentialSettingsArgs.builder()
.enable(false)
.build())
.location("northeurope")
.resourceGroupName("testrg")
.serverConfigurationsManagementSettings(ServerConfigurationsManagementSettingsArgs.builder()
.additionalFeaturesServerConfigurations(AdditionalFeaturesServerConfigurationsArgs.builder()
.isRServicesEnabled(false)
.build())
.sqlConnectivityUpdateSettings(SqlConnectivityUpdateSettingsArgs.builder()
.connectivityType("PRIVATE")
.port(1433)
.sqlAuthUpdatePassword("<password>")
.sqlAuthUpdateUserName("sqllogin")
.build())
.sqlStorageUpdateSettings(SqlStorageUpdateSettingsArgs.builder()
.diskConfigurationType("NEW")
.diskCount(1)
.startingDeviceId(2)
.build())
.sqlWorkloadTypeUpdateSettings(SqlWorkloadTypeUpdateSettingsArgs.builder()
.sqlWorkloadType("OLTP")
.build())
.build())
.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={
"backup_schedule_type": azure_native.sqlvirtualmachine.BackupScheduleType.MANUAL,
"backup_system_dbs": True,
"days_of_week": [
azure_native.sqlvirtualmachine.AutoBackupDaysOfWeek.MONDAY,
azure_native.sqlvirtualmachine.AutoBackupDaysOfWeek.FRIDAY,
],
"enable": True,
"enable_encryption": True,
"full_backup_frequency": azure_native.sqlvirtualmachine.FullBackupFrequencyType.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={
"day_of_week": azure_native.sqlvirtualmachine.DayOfWeek.SUNDAY,
"enable": True,
"maintenance_window_duration": 60,
"maintenance_window_starting_hour": 2,
},
key_vault_credential_settings={
"enable": False,
},
location="northeurope",
resource_group_name="testrg",
server_configurations_management_settings={
"additional_features_server_configurations": {
"is_r_services_enabled": False,
},
"sql_connectivity_update_settings": {
"connectivity_type": azure_native.sqlvirtualmachine.ConnectivityType.PRIVATE,
"port": 1433,
"sql_auth_update_password": "<password>",
"sql_auth_update_user_name": "sqllogin",
},
"sql_storage_update_settings": {
"disk_configuration_type": azure_native.sqlvirtualmachine.DiskConfigurationType.NEW,
"disk_count": 1,
"starting_device_id": 2,
},
"sql_workload_type_update_settings": {
"sql_workload_type": azure_native.sqlvirtualmachine.SqlWorkloadType.OLTP,
},
},
sql_image_sku=azure_native.sqlvirtualmachine.SqlImageSku.ENTERPRISE,
sql_management=azure_native.sqlvirtualmachine.SqlManagementMode.FULL,
sql_server_license_type=azure_native.sqlvirtualmachine.SqlServerLicenseType.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: azure_native.sqlvirtualmachine.BackupScheduleType.Manual,
backupSystemDbs: true,
daysOfWeek: [
azure_native.sqlvirtualmachine.AutoBackupDaysOfWeek.Monday,
azure_native.sqlvirtualmachine.AutoBackupDaysOfWeek.Friday,
],
enable: true,
enableEncryption: true,
fullBackupFrequency: azure_native.sqlvirtualmachine.FullBackupFrequencyType.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: azure_native.sqlvirtualmachine.ConnectivityType.PRIVATE,
port: 1433,
sqlAuthUpdatePassword: "<password>",
sqlAuthUpdateUserName: "sqllogin",
},
sqlStorageUpdateSettings: {
diskConfigurationType: azure_native.sqlvirtualmachine.DiskConfigurationType.NEW,
diskCount: 1,
startingDeviceId: 2,
},
sqlWorkloadTypeUpdateSettings: {
sqlWorkloadType: azure_native.sqlvirtualmachine.SqlWorkloadType.OLTP,
},
},
sqlImageSku: azure_native.sqlvirtualmachine.SqlImageSku.Enterprise,
sqlManagement: azure_native.sqlvirtualmachine.SqlManagementMode.Full,
sqlServerLicenseType: azure_native.sqlvirtualmachine.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 = AzureNative.SqlVirtualMachine.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 (
sqlvirtualmachine "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.StorageConfigurationSettingsArgs{
DiskConfigurationType: pulumi.String(sqlvirtualmachine.DiskConfigurationTypeEXTEND),
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 com.pulumi.azurenative.sqlvirtualmachine.inputs.StorageConfigurationSettingsArgs;
import com.pulumi.azurenative.sqlvirtualmachine.inputs.SQLStorageSettingsArgs;
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(StorageConfigurationSettingsArgs.builder()
.diskConfigurationType("EXTEND")
.sqlDataSettings(SQLStorageSettingsArgs.builder()
.luns(2)
.build())
.build())
.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={
"disk_configuration_type": azure_native.sqlvirtualmachine.DiskConfigurationType.EXTEND,
"sql_data_settings": {
"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: azure_native.sqlvirtualmachine.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 = AzureNative.SqlVirtualMachine.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 = AzureNative.SqlVirtualMachine.StorageWorkloadType.OLTP,
},
VirtualMachineResourceId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm",
});
});
package main
import (
sqlvirtualmachine "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.StorageConfigurationSettingsArgs{
DiskConfigurationType: pulumi.String(sqlvirtualmachine.DiskConfigurationTypeNEW),
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(sqlvirtualmachine.StorageWorkloadTypeOLTP),
},
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 com.pulumi.azurenative.sqlvirtualmachine.inputs.StorageConfigurationSettingsArgs;
import com.pulumi.azurenative.sqlvirtualmachine.inputs.SQLStorageSettingsArgs;
import com.pulumi.azurenative.sqlvirtualmachine.inputs.SQLTempDbSettingsArgs;
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(StorageConfigurationSettingsArgs.builder()
.diskConfigurationType("NEW")
.sqlDataSettings(SQLStorageSettingsArgs.builder()
.defaultFilePath("F:\\folderpath\\")
.luns(0)
.build())
.sqlLogSettings(SQLStorageSettingsArgs.builder()
.defaultFilePath("G:\\folderpath\\")
.luns(1)
.build())
.sqlSystemDbOnDataDisk(true)
.sqlTempDbSettings(SQLTempDbSettingsArgs.builder()
.dataFileCount(8)
.dataFileSize(256)
.dataGrowth(512)
.defaultFilePath("D:\\TEMP")
.logFileSize(256)
.logGrowth(512)
.build())
.storageWorkloadType("OLTP")
.build())
.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={
"disk_configuration_type": azure_native.sqlvirtualmachine.DiskConfigurationType.NEW,
"sql_data_settings": {
"default_file_path": "F:\\folderpath\\",
"luns": [0],
},
"sql_log_settings": {
"default_file_path": "G:\\folderpath\\",
"luns": [1],
},
"sql_system_db_on_data_disk": True,
"sql_temp_db_settings": {
"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": azure_native.sqlvirtualmachine.StorageWorkloadType.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: azure_native.sqlvirtualmachine.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: azure_native.sqlvirtualmachine.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 = AzureNative.SqlVirtualMachine.BackupScheduleType.Manual,
BackupSystemDbs = true,
Enable = true,
EnableEncryption = true,
FullBackupFrequency = AzureNative.SqlVirtualMachine.FullBackupFrequencyType.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 = AzureNative.SqlVirtualMachine.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 = AzureNative.SqlVirtualMachine.DiskConfigurationType.NEW,
DiskCount = 1,
StartingDeviceId = 2,
},
SqlWorkloadTypeUpdateSettings = new AzureNative.SqlVirtualMachine.Inputs.SqlWorkloadTypeUpdateSettingsArgs
{
SqlWorkloadType = AzureNative.SqlVirtualMachine.SqlWorkloadType.OLTP,
},
},
SqlImageSku = AzureNative.SqlVirtualMachine.SqlImageSku.Enterprise,
SqlManagement = AzureNative.SqlVirtualMachine.SqlManagementMode.Full,
SqlServerLicenseType = AzureNative.SqlVirtualMachine.SqlServerLicenseType.PAYG,
SqlVirtualMachineName = "testvm",
VirtualMachineResourceId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm",
});
});
package main
import (
sqlvirtualmachine "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.AssessmentSettingsArgs{
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(sqlvirtualmachine.BackupScheduleTypeManual),
BackupSystemDbs: pulumi.Bool(true),
Enable: pulumi.Bool(true),
EnableEncryption: pulumi.Bool(true),
FullBackupFrequency: pulumi.String(sqlvirtualmachine.FullBackupFrequencyTypeDaily),
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.ServerConfigurationsManagementSettingsArgs{
AdditionalFeaturesServerConfigurations: &sqlvirtualmachine.AdditionalFeaturesServerConfigurationsArgs{
IsRServicesEnabled: pulumi.Bool(false),
},
SqlConnectivityUpdateSettings: &sqlvirtualmachine.SqlConnectivityUpdateSettingsArgs{
ConnectivityType: pulumi.String(sqlvirtualmachine.ConnectivityTypePRIVATE),
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(sqlvirtualmachine.DiskConfigurationTypeNEW),
DiskCount: pulumi.Int(1),
StartingDeviceId: pulumi.Int(2),
},
SqlWorkloadTypeUpdateSettings: &sqlvirtualmachine.SqlWorkloadTypeUpdateSettingsArgs{
SqlWorkloadType: pulumi.String(sqlvirtualmachine.SqlWorkloadTypeOLTP),
},
},
SqlImageSku: pulumi.String(sqlvirtualmachine.SqlImageSkuEnterprise),
SqlManagement: pulumi.String(sqlvirtualmachine.SqlManagementModeFull),
SqlServerLicenseType: pulumi.String(sqlvirtualmachine.SqlServerLicenseTypePAYG),
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 com.pulumi.azurenative.sqlvirtualmachine.inputs.AssessmentSettingsArgs;
import com.pulumi.azurenative.sqlvirtualmachine.inputs.ScheduleArgs;
import com.pulumi.azurenative.sqlvirtualmachine.inputs.AutoBackupSettingsArgs;
import com.pulumi.azurenative.sqlvirtualmachine.inputs.AutoPatchingSettingsArgs;
import com.pulumi.azurenative.sqlvirtualmachine.inputs.KeyVaultCredentialSettingsArgs;
import com.pulumi.azurenative.sqlvirtualmachine.inputs.ServerConfigurationsManagementSettingsArgs;
import com.pulumi.azurenative.sqlvirtualmachine.inputs.AdditionalFeaturesServerConfigurationsArgs;
import com.pulumi.azurenative.sqlvirtualmachine.inputs.SqlConnectivityUpdateSettingsArgs;
import com.pulumi.azurenative.sqlvirtualmachine.inputs.SQLInstanceSettingsArgs;
import com.pulumi.azurenative.sqlvirtualmachine.inputs.SqlStorageUpdateSettingsArgs;
import com.pulumi.azurenative.sqlvirtualmachine.inputs.SqlWorkloadTypeUpdateSettingsArgs;
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(AssessmentSettingsArgs.builder()
.enable(true)
.runImmediately(true)
.schedule(ScheduleArgs.builder()
.dayOfWeek("Sunday")
.enable(true)
.startTime("23:17")
.weeklyInterval(1)
.build())
.build())
.autoBackupSettings(AutoBackupSettingsArgs.builder()
.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")
.build())
.autoPatchingSettings(AutoPatchingSettingsArgs.builder()
.dayOfWeek("Sunday")
.enable(true)
.maintenanceWindowDuration(60)
.maintenanceWindowStartingHour(2)
.build())
.keyVaultCredentialSettings(KeyVaultCredentialSettingsArgs.builder()
.enable(false)
.build())
.location("northeurope")
.resourceGroupName("testrg")
.serverConfigurationsManagementSettings(ServerConfigurationsManagementSettingsArgs.builder()
.additionalFeaturesServerConfigurations(AdditionalFeaturesServerConfigurationsArgs.builder()
.isRServicesEnabled(false)
.build())
.sqlConnectivityUpdateSettings(SqlConnectivityUpdateSettingsArgs.builder()
.connectivityType("PRIVATE")
.port(1433)
.sqlAuthUpdatePassword("<password>")
.sqlAuthUpdateUserName("sqllogin")
.build())
.sqlInstanceSettings(SQLInstanceSettingsArgs.builder()
.collation("SQL_Latin1_General_CP1_CI_AS")
.isIfiEnabled(true)
.isLpimEnabled(true)
.isOptimizeForAdHocWorkloadsEnabled(true)
.maxDop(8)
.maxServerMemoryMB(128)
.minServerMemoryMB(0)
.build())
.sqlStorageUpdateSettings(SqlStorageUpdateSettingsArgs.builder()
.diskConfigurationType("NEW")
.diskCount(1)
.startingDeviceId(2)
.build())
.sqlWorkloadTypeUpdateSettings(SqlWorkloadTypeUpdateSettingsArgs.builder()
.sqlWorkloadType("OLTP")
.build())
.build())
.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={
"enable": True,
"run_immediately": True,
"schedule": {
"day_of_week": azure_native.sqlvirtualmachine.AssessmentDayOfWeek.SUNDAY,
"enable": True,
"start_time": "23:17",
"weekly_interval": 1,
},
},
auto_backup_settings={
"backup_schedule_type": azure_native.sqlvirtualmachine.BackupScheduleType.MANUAL,
"backup_system_dbs": True,
"enable": True,
"enable_encryption": True,
"full_backup_frequency": azure_native.sqlvirtualmachine.FullBackupFrequencyType.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={
"day_of_week": azure_native.sqlvirtualmachine.DayOfWeek.SUNDAY,
"enable": True,
"maintenance_window_duration": 60,
"maintenance_window_starting_hour": 2,
},
key_vault_credential_settings={
"enable": False,
},
location="northeurope",
resource_group_name="testrg",
server_configurations_management_settings={
"additional_features_server_configurations": {
"is_r_services_enabled": False,
},
"sql_connectivity_update_settings": {
"connectivity_type": azure_native.sqlvirtualmachine.ConnectivityType.PRIVATE,
"port": 1433,
"sql_auth_update_password": "<password>",
"sql_auth_update_user_name": "sqllogin",
},
"sql_instance_settings": {
"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": {
"disk_configuration_type": azure_native.sqlvirtualmachine.DiskConfigurationType.NEW,
"disk_count": 1,
"starting_device_id": 2,
},
"sql_workload_type_update_settings": {
"sql_workload_type": azure_native.sqlvirtualmachine.SqlWorkloadType.OLTP,
},
},
sql_image_sku=azure_native.sqlvirtualmachine.SqlImageSku.ENTERPRISE,
sql_management=azure_native.sqlvirtualmachine.SqlManagementMode.FULL,
sql_server_license_type=azure_native.sqlvirtualmachine.SqlServerLicenseType.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: azure_native.sqlvirtualmachine.BackupScheduleType.Manual,
backupSystemDbs: true,
enable: true,
enableEncryption: true,
fullBackupFrequency: azure_native.sqlvirtualmachine.FullBackupFrequencyType.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: azure_native.sqlvirtualmachine.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: azure_native.sqlvirtualmachine.DiskConfigurationType.NEW,
diskCount: 1,
startingDeviceId: 2,
},
sqlWorkloadTypeUpdateSettings: {
sqlWorkloadType: azure_native.sqlvirtualmachine.SqlWorkloadType.OLTP,
},
},
sqlImageSku: azure_native.sqlvirtualmachine.SqlImageSku.Enterprise,
sqlManagement: azure_native.sqlvirtualmachine.SqlManagementMode.Full,
sqlServerLicenseType: azure_native.sqlvirtualmachine.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 (
sqlvirtualmachine "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
Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.
Constructor syntax
new SqlVirtualMachine(name: string, args: SqlVirtualMachineArgs, opts?: CustomResourceOptions);@overload
def SqlVirtualMachine(resource_name: str,
args: SqlVirtualMachineArgs,
opts: Optional[ResourceOptions] = None)
@overload
def SqlVirtualMachine(resource_name: str,
opts: Optional[ResourceOptions] = None,
resource_group_name: Optional[str] = None,
sql_image_offer: Optional[str] = None,
identity: Optional[ResourceIdentityArgs] = None,
sql_management: Optional[Union[str, SqlManagementMode]] = None,
sql_server_license_type: Optional[Union[str, SqlServerLicenseType]] = None,
location: Optional[str] = None,
auto_backup_settings: Optional[AutoBackupSettingsArgs] = None,
server_configurations_management_settings: Optional[ServerConfigurationsManagementSettingsArgs] = None,
assessment_settings: Optional[AssessmentSettingsArgs] = None,
wsfc_static_ip: Optional[str] = None,
auto_patching_settings: Optional[AutoPatchingSettingsArgs] = None,
key_vault_credential_settings: Optional[KeyVaultCredentialSettingsArgs] = 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,
sql_image_sku: Optional[Union[str, SqlImageSku]] = 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.
Parameters
- 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.
Constructor example
The following reference example uses placeholder values for all input properties.
var sqlVirtualMachineResource = new AzureNative.SqlVirtualMachine.SqlVirtualMachine("sqlVirtualMachineResource", new()
{
ResourceGroupName = "string",
SqlImageOffer = "string",
Identity = new AzureNative.SqlVirtualMachine.Inputs.ResourceIdentityArgs
{
Type = "string",
},
SqlManagement = "string",
SqlServerLicenseType = "string",
Location = "string",
AutoBackupSettings = new AzureNative.SqlVirtualMachine.Inputs.AutoBackupSettingsArgs
{
BackupScheduleType = "string",
BackupSystemDbs = false,
DaysOfWeek = new[]
{
"string",
},
Enable = false,
EnableEncryption = false,
FullBackupFrequency = "string",
FullBackupStartTime = 0,
FullBackupWindowHours = 0,
LogBackupFrequency = 0,
Password = "string",
RetentionPeriod = 0,
StorageAccessKey = "string",
StorageAccountUrl = "string",
StorageContainerName = "string",
},
ServerConfigurationsManagementSettings = new AzureNative.SqlVirtualMachine.Inputs.ServerConfigurationsManagementSettingsArgs
{
AdditionalFeaturesServerConfigurations = new AzureNative.SqlVirtualMachine.Inputs.AdditionalFeaturesServerConfigurationsArgs
{
IsRServicesEnabled = false,
},
SqlConnectivityUpdateSettings = new AzureNative.SqlVirtualMachine.Inputs.SqlConnectivityUpdateSettingsArgs
{
ConnectivityType = "string",
Port = 0,
SqlAuthUpdatePassword = "string",
SqlAuthUpdateUserName = "string",
},
SqlInstanceSettings = new AzureNative.SqlVirtualMachine.Inputs.SQLInstanceSettingsArgs
{
Collation = "string",
IsIfiEnabled = false,
IsLpimEnabled = false,
IsOptimizeForAdHocWorkloadsEnabled = false,
MaxDop = 0,
MaxServerMemoryMB = 0,
MinServerMemoryMB = 0,
},
SqlStorageUpdateSettings = new AzureNative.SqlVirtualMachine.Inputs.SqlStorageUpdateSettingsArgs
{
DiskConfigurationType = "string",
DiskCount = 0,
StartingDeviceId = 0,
},
SqlWorkloadTypeUpdateSettings = new AzureNative.SqlVirtualMachine.Inputs.SqlWorkloadTypeUpdateSettingsArgs
{
SqlWorkloadType = "string",
},
},
AssessmentSettings = new AzureNative.SqlVirtualMachine.Inputs.AssessmentSettingsArgs
{
Enable = false,
RunImmediately = false,
Schedule = new AzureNative.SqlVirtualMachine.Inputs.ScheduleArgs
{
DayOfWeek = AzureNative.SqlVirtualMachine.AssessmentDayOfWeek.Monday,
Enable = false,
MonthlyOccurrence = 0,
StartTime = "string",
WeeklyInterval = 0,
},
},
WsfcStaticIp = "string",
AutoPatchingSettings = new AzureNative.SqlVirtualMachine.Inputs.AutoPatchingSettingsArgs
{
DayOfWeek = AzureNative.SqlVirtualMachine.DayOfWeek.Everyday,
Enable = false,
MaintenanceWindowDuration = 0,
MaintenanceWindowStartingHour = 0,
},
KeyVaultCredentialSettings = new AzureNative.SqlVirtualMachine.Inputs.KeyVaultCredentialSettingsArgs
{
AzureKeyVaultUrl = "string",
CredentialName = "string",
Enable = false,
ServicePrincipalName = "string",
ServicePrincipalSecret = "string",
},
SqlVirtualMachineGroupResourceId = "string",
SqlVirtualMachineName = "string",
StorageConfigurationSettings = new AzureNative.SqlVirtualMachine.Inputs.StorageConfigurationSettingsArgs
{
DiskConfigurationType = "string",
SqlDataSettings = new AzureNative.SqlVirtualMachine.Inputs.SQLStorageSettingsArgs
{
DefaultFilePath = "string",
Luns = new[]
{
0,
},
},
SqlLogSettings = new AzureNative.SqlVirtualMachine.Inputs.SQLStorageSettingsArgs
{
DefaultFilePath = "string",
Luns = new[]
{
0,
},
},
SqlSystemDbOnDataDisk = false,
SqlTempDbSettings = new AzureNative.SqlVirtualMachine.Inputs.SQLTempDbSettingsArgs
{
DataFileCount = 0,
DataFileSize = 0,
DataGrowth = 0,
DefaultFilePath = "string",
LogFileSize = 0,
LogGrowth = 0,
Luns = new[]
{
0,
},
PersistFolder = false,
PersistFolderPath = "string",
},
StorageWorkloadType = "string",
},
Tags =
{
{ "string", "string" },
},
VirtualMachineResourceId = "string",
WsfcDomainCredentials = new AzureNative.SqlVirtualMachine.Inputs.WsfcDomainCredentialsArgs
{
ClusterBootstrapAccountPassword = "string",
ClusterOperatorAccountPassword = "string",
SqlServiceAccountPassword = "string",
},
SqlImageSku = "string",
});
example, err := sqlvirtualmachine.NewSqlVirtualMachine(ctx, "sqlVirtualMachineResource", &sqlvirtualmachine.SqlVirtualMachineArgs{
ResourceGroupName: pulumi.String("string"),
SqlImageOffer: pulumi.String("string"),
Identity: &sqlvirtualmachine.ResourceIdentityArgs{
Type: pulumi.String("string"),
},
SqlManagement: pulumi.String("string"),
SqlServerLicenseType: pulumi.String("string"),
Location: pulumi.String("string"),
AutoBackupSettings: &sqlvirtualmachine.AutoBackupSettingsArgs{
BackupScheduleType: pulumi.String("string"),
BackupSystemDbs: pulumi.Bool(false),
DaysOfWeek: pulumi.StringArray{
pulumi.String("string"),
},
Enable: pulumi.Bool(false),
EnableEncryption: pulumi.Bool(false),
FullBackupFrequency: pulumi.String("string"),
FullBackupStartTime: pulumi.Int(0),
FullBackupWindowHours: pulumi.Int(0),
LogBackupFrequency: pulumi.Int(0),
Password: pulumi.String("string"),
RetentionPeriod: pulumi.Int(0),
StorageAccessKey: pulumi.String("string"),
StorageAccountUrl: pulumi.String("string"),
StorageContainerName: pulumi.String("string"),
},
ServerConfigurationsManagementSettings: &sqlvirtualmachine.ServerConfigurationsManagementSettingsArgs{
AdditionalFeaturesServerConfigurations: &sqlvirtualmachine.AdditionalFeaturesServerConfigurationsArgs{
IsRServicesEnabled: pulumi.Bool(false),
},
SqlConnectivityUpdateSettings: &sqlvirtualmachine.SqlConnectivityUpdateSettingsArgs{
ConnectivityType: pulumi.String("string"),
Port: pulumi.Int(0),
SqlAuthUpdatePassword: pulumi.String("string"),
SqlAuthUpdateUserName: pulumi.String("string"),
},
SqlInstanceSettings: &sqlvirtualmachine.SQLInstanceSettingsArgs{
Collation: pulumi.String("string"),
IsIfiEnabled: pulumi.Bool(false),
IsLpimEnabled: pulumi.Bool(false),
IsOptimizeForAdHocWorkloadsEnabled: pulumi.Bool(false),
MaxDop: pulumi.Int(0),
MaxServerMemoryMB: pulumi.Int(0),
MinServerMemoryMB: pulumi.Int(0),
},
SqlStorageUpdateSettings: &sqlvirtualmachine.SqlStorageUpdateSettingsArgs{
DiskConfigurationType: pulumi.String("string"),
DiskCount: pulumi.Int(0),
StartingDeviceId: pulumi.Int(0),
},
SqlWorkloadTypeUpdateSettings: &sqlvirtualmachine.SqlWorkloadTypeUpdateSettingsArgs{
SqlWorkloadType: pulumi.String("string"),
},
},
AssessmentSettings: &sqlvirtualmachine.AssessmentSettingsArgs{
Enable: pulumi.Bool(false),
RunImmediately: pulumi.Bool(false),
Schedule: &sqlvirtualmachine.ScheduleArgs{
DayOfWeek: sqlvirtualmachine.AssessmentDayOfWeekMonday,
Enable: pulumi.Bool(false),
MonthlyOccurrence: pulumi.Int(0),
StartTime: pulumi.String("string"),
WeeklyInterval: pulumi.Int(0),
},
},
WsfcStaticIp: pulumi.String("string"),
AutoPatchingSettings: &sqlvirtualmachine.AutoPatchingSettingsArgs{
DayOfWeek: sqlvirtualmachine.DayOfWeekEveryday,
Enable: pulumi.Bool(false),
MaintenanceWindowDuration: pulumi.Int(0),
MaintenanceWindowStartingHour: pulumi.Int(0),
},
KeyVaultCredentialSettings: &sqlvirtualmachine.KeyVaultCredentialSettingsArgs{
AzureKeyVaultUrl: pulumi.String("string"),
CredentialName: pulumi.String("string"),
Enable: pulumi.Bool(false),
ServicePrincipalName: pulumi.String("string"),
ServicePrincipalSecret: pulumi.String("string"),
},
SqlVirtualMachineGroupResourceId: pulumi.String("string"),
SqlVirtualMachineName: pulumi.String("string"),
StorageConfigurationSettings: &sqlvirtualmachine.StorageConfigurationSettingsArgs{
DiskConfigurationType: pulumi.String("string"),
SqlDataSettings: &sqlvirtualmachine.SQLStorageSettingsArgs{
DefaultFilePath: pulumi.String("string"),
Luns: pulumi.IntArray{
pulumi.Int(0),
},
},
SqlLogSettings: &sqlvirtualmachine.SQLStorageSettingsArgs{
DefaultFilePath: pulumi.String("string"),
Luns: pulumi.IntArray{
pulumi.Int(0),
},
},
SqlSystemDbOnDataDisk: pulumi.Bool(false),
SqlTempDbSettings: &sqlvirtualmachine.SQLTempDbSettingsArgs{
DataFileCount: pulumi.Int(0),
DataFileSize: pulumi.Int(0),
DataGrowth: pulumi.Int(0),
DefaultFilePath: pulumi.String("string"),
LogFileSize: pulumi.Int(0),
LogGrowth: pulumi.Int(0),
Luns: pulumi.IntArray{
pulumi.Int(0),
},
PersistFolder: pulumi.Bool(false),
PersistFolderPath: pulumi.String("string"),
},
StorageWorkloadType: pulumi.String("string"),
},
Tags: pulumi.StringMap{
"string": pulumi.String("string"),
},
VirtualMachineResourceId: pulumi.String("string"),
WsfcDomainCredentials: &sqlvirtualmachine.WsfcDomainCredentialsArgs{
ClusterBootstrapAccountPassword: pulumi.String("string"),
ClusterOperatorAccountPassword: pulumi.String("string"),
SqlServiceAccountPassword: pulumi.String("string"),
},
SqlImageSku: pulumi.String("string"),
})
var sqlVirtualMachineResource = new SqlVirtualMachine("sqlVirtualMachineResource", SqlVirtualMachineArgs.builder()
.resourceGroupName("string")
.sqlImageOffer("string")
.identity(ResourceIdentityArgs.builder()
.type("string")
.build())
.sqlManagement("string")
.sqlServerLicenseType("string")
.location("string")
.autoBackupSettings(AutoBackupSettingsArgs.builder()
.backupScheduleType("string")
.backupSystemDbs(false)
.daysOfWeek("string")
.enable(false)
.enableEncryption(false)
.fullBackupFrequency("string")
.fullBackupStartTime(0)
.fullBackupWindowHours(0)
.logBackupFrequency(0)
.password("string")
.retentionPeriod(0)
.storageAccessKey("string")
.storageAccountUrl("string")
.storageContainerName("string")
.build())
.serverConfigurationsManagementSettings(ServerConfigurationsManagementSettingsArgs.builder()
.additionalFeaturesServerConfigurations(AdditionalFeaturesServerConfigurationsArgs.builder()
.isRServicesEnabled(false)
.build())
.sqlConnectivityUpdateSettings(SqlConnectivityUpdateSettingsArgs.builder()
.connectivityType("string")
.port(0)
.sqlAuthUpdatePassword("string")
.sqlAuthUpdateUserName("string")
.build())
.sqlInstanceSettings(SQLInstanceSettingsArgs.builder()
.collation("string")
.isIfiEnabled(false)
.isLpimEnabled(false)
.isOptimizeForAdHocWorkloadsEnabled(false)
.maxDop(0)
.maxServerMemoryMB(0)
.minServerMemoryMB(0)
.build())
.sqlStorageUpdateSettings(SqlStorageUpdateSettingsArgs.builder()
.diskConfigurationType("string")
.diskCount(0)
.startingDeviceId(0)
.build())
.sqlWorkloadTypeUpdateSettings(SqlWorkloadTypeUpdateSettingsArgs.builder()
.sqlWorkloadType("string")
.build())
.build())
.assessmentSettings(AssessmentSettingsArgs.builder()
.enable(false)
.runImmediately(false)
.schedule(ScheduleArgs.builder()
.dayOfWeek("Monday")
.enable(false)
.monthlyOccurrence(0)
.startTime("string")
.weeklyInterval(0)
.build())
.build())
.wsfcStaticIp("string")
.autoPatchingSettings(AutoPatchingSettingsArgs.builder()
.dayOfWeek("Everyday")
.enable(false)
.maintenanceWindowDuration(0)
.maintenanceWindowStartingHour(0)
.build())
.keyVaultCredentialSettings(KeyVaultCredentialSettingsArgs.builder()
.azureKeyVaultUrl("string")
.credentialName("string")
.enable(false)
.servicePrincipalName("string")
.servicePrincipalSecret("string")
.build())
.sqlVirtualMachineGroupResourceId("string")
.sqlVirtualMachineName("string")
.storageConfigurationSettings(StorageConfigurationSettingsArgs.builder()
.diskConfigurationType("string")
.sqlDataSettings(SQLStorageSettingsArgs.builder()
.defaultFilePath("string")
.luns(0)
.build())
.sqlLogSettings(SQLStorageSettingsArgs.builder()
.defaultFilePath("string")
.luns(0)
.build())
.sqlSystemDbOnDataDisk(false)
.sqlTempDbSettings(SQLTempDbSettingsArgs.builder()
.dataFileCount(0)
.dataFileSize(0)
.dataGrowth(0)
.defaultFilePath("string")
.logFileSize(0)
.logGrowth(0)
.luns(0)
.persistFolder(false)
.persistFolderPath("string")
.build())
.storageWorkloadType("string")
.build())
.tags(Map.of("string", "string"))
.virtualMachineResourceId("string")
.wsfcDomainCredentials(WsfcDomainCredentialsArgs.builder()
.clusterBootstrapAccountPassword("string")
.clusterOperatorAccountPassword("string")
.sqlServiceAccountPassword("string")
.build())
.sqlImageSku("string")
.build());
sql_virtual_machine_resource = azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachineResource",
resource_group_name="string",
sql_image_offer="string",
identity={
"type": "string",
},
sql_management="string",
sql_server_license_type="string",
location="string",
auto_backup_settings={
"backupScheduleType": "string",
"backupSystemDbs": False,
"daysOfWeek": ["string"],
"enable": False,
"enableEncryption": False,
"fullBackupFrequency": "string",
"fullBackupStartTime": 0,
"fullBackupWindowHours": 0,
"logBackupFrequency": 0,
"password": "string",
"retentionPeriod": 0,
"storageAccessKey": "string",
"storageAccountUrl": "string",
"storageContainerName": "string",
},
server_configurations_management_settings={
"additionalFeaturesServerConfigurations": {
"isRServicesEnabled": False,
},
"sqlConnectivityUpdateSettings": {
"connectivityType": "string",
"port": 0,
"sqlAuthUpdatePassword": "string",
"sqlAuthUpdateUserName": "string",
},
"sqlInstanceSettings": {
"collation": "string",
"isIfiEnabled": False,
"isLpimEnabled": False,
"isOptimizeForAdHocWorkloadsEnabled": False,
"maxDop": 0,
"maxServerMemoryMB": 0,
"minServerMemoryMB": 0,
},
"sqlStorageUpdateSettings": {
"diskConfigurationType": "string",
"diskCount": 0,
"startingDeviceId": 0,
},
"sqlWorkloadTypeUpdateSettings": {
"sqlWorkloadType": "string",
},
},
assessment_settings={
"enable": False,
"runImmediately": False,
"schedule": {
"dayOfWeek": azure_native.sqlvirtualmachine.AssessmentDayOfWeek.MONDAY,
"enable": False,
"monthlyOccurrence": 0,
"startTime": "string",
"weeklyInterval": 0,
},
},
wsfc_static_ip="string",
auto_patching_settings={
"dayOfWeek": azure_native.sqlvirtualmachine.DayOfWeek.EVERYDAY,
"enable": False,
"maintenanceWindowDuration": 0,
"maintenanceWindowStartingHour": 0,
},
key_vault_credential_settings={
"azureKeyVaultUrl": "string",
"credentialName": "string",
"enable": False,
"servicePrincipalName": "string",
"servicePrincipalSecret": "string",
},
sql_virtual_machine_group_resource_id="string",
sql_virtual_machine_name="string",
storage_configuration_settings={
"diskConfigurationType": "string",
"sqlDataSettings": {
"defaultFilePath": "string",
"luns": [0],
},
"sqlLogSettings": {
"defaultFilePath": "string",
"luns": [0],
},
"sqlSystemDbOnDataDisk": False,
"sqlTempDbSettings": {
"dataFileCount": 0,
"dataFileSize": 0,
"dataGrowth": 0,
"defaultFilePath": "string",
"logFileSize": 0,
"logGrowth": 0,
"luns": [0],
"persistFolder": False,
"persistFolderPath": "string",
},
"storageWorkloadType": "string",
},
tags={
"string": "string",
},
virtual_machine_resource_id="string",
wsfc_domain_credentials={
"clusterBootstrapAccountPassword": "string",
"clusterOperatorAccountPassword": "string",
"sqlServiceAccountPassword": "string",
},
sql_image_sku="string")
const sqlVirtualMachineResource = new azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachineResource", {
resourceGroupName: "string",
sqlImageOffer: "string",
identity: {
type: "string",
},
sqlManagement: "string",
sqlServerLicenseType: "string",
location: "string",
autoBackupSettings: {
backupScheduleType: "string",
backupSystemDbs: false,
daysOfWeek: ["string"],
enable: false,
enableEncryption: false,
fullBackupFrequency: "string",
fullBackupStartTime: 0,
fullBackupWindowHours: 0,
logBackupFrequency: 0,
password: "string",
retentionPeriod: 0,
storageAccessKey: "string",
storageAccountUrl: "string",
storageContainerName: "string",
},
serverConfigurationsManagementSettings: {
additionalFeaturesServerConfigurations: {
isRServicesEnabled: false,
},
sqlConnectivityUpdateSettings: {
connectivityType: "string",
port: 0,
sqlAuthUpdatePassword: "string",
sqlAuthUpdateUserName: "string",
},
sqlInstanceSettings: {
collation: "string",
isIfiEnabled: false,
isLpimEnabled: false,
isOptimizeForAdHocWorkloadsEnabled: false,
maxDop: 0,
maxServerMemoryMB: 0,
minServerMemoryMB: 0,
},
sqlStorageUpdateSettings: {
diskConfigurationType: "string",
diskCount: 0,
startingDeviceId: 0,
},
sqlWorkloadTypeUpdateSettings: {
sqlWorkloadType: "string",
},
},
assessmentSettings: {
enable: false,
runImmediately: false,
schedule: {
dayOfWeek: azure_native.sqlvirtualmachine.AssessmentDayOfWeek.Monday,
enable: false,
monthlyOccurrence: 0,
startTime: "string",
weeklyInterval: 0,
},
},
wsfcStaticIp: "string",
autoPatchingSettings: {
dayOfWeek: azure_native.sqlvirtualmachine.DayOfWeek.Everyday,
enable: false,
maintenanceWindowDuration: 0,
maintenanceWindowStartingHour: 0,
},
keyVaultCredentialSettings: {
azureKeyVaultUrl: "string",
credentialName: "string",
enable: false,
servicePrincipalName: "string",
servicePrincipalSecret: "string",
},
sqlVirtualMachineGroupResourceId: "string",
sqlVirtualMachineName: "string",
storageConfigurationSettings: {
diskConfigurationType: "string",
sqlDataSettings: {
defaultFilePath: "string",
luns: [0],
},
sqlLogSettings: {
defaultFilePath: "string",
luns: [0],
},
sqlSystemDbOnDataDisk: false,
sqlTempDbSettings: {
dataFileCount: 0,
dataFileSize: 0,
dataGrowth: 0,
defaultFilePath: "string",
logFileSize: 0,
logGrowth: 0,
luns: [0],
persistFolder: false,
persistFolderPath: "string",
},
storageWorkloadType: "string",
},
tags: {
string: "string",
},
virtualMachineResourceId: "string",
wsfcDomainCredentials: {
clusterBootstrapAccountPassword: "string",
clusterOperatorAccountPassword: "string",
sqlServiceAccountPassword: "string",
},
sqlImageSku: "string",
});
type: azure-native:sqlvirtualmachine:SqlVirtualMachine
properties:
assessmentSettings:
enable: false
runImmediately: false
schedule:
dayOfWeek: Monday
enable: false
monthlyOccurrence: 0
startTime: string
weeklyInterval: 0
autoBackupSettings:
backupScheduleType: string
backupSystemDbs: false
daysOfWeek:
- string
enable: false
enableEncryption: false
fullBackupFrequency: string
fullBackupStartTime: 0
fullBackupWindowHours: 0
logBackupFrequency: 0
password: string
retentionPeriod: 0
storageAccessKey: string
storageAccountUrl: string
storageContainerName: string
autoPatchingSettings:
dayOfWeek: Everyday
enable: false
maintenanceWindowDuration: 0
maintenanceWindowStartingHour: 0
identity:
type: string
keyVaultCredentialSettings:
azureKeyVaultUrl: string
credentialName: string
enable: false
servicePrincipalName: string
servicePrincipalSecret: string
location: string
resourceGroupName: string
serverConfigurationsManagementSettings:
additionalFeaturesServerConfigurations:
isRServicesEnabled: false
sqlConnectivityUpdateSettings:
connectivityType: string
port: 0
sqlAuthUpdatePassword: string
sqlAuthUpdateUserName: string
sqlInstanceSettings:
collation: string
isIfiEnabled: false
isLpimEnabled: false
isOptimizeForAdHocWorkloadsEnabled: false
maxDop: 0
maxServerMemoryMB: 0
minServerMemoryMB: 0
sqlStorageUpdateSettings:
diskConfigurationType: string
diskCount: 0
startingDeviceId: 0
sqlWorkloadTypeUpdateSettings:
sqlWorkloadType: string
sqlImageOffer: string
sqlImageSku: string
sqlManagement: string
sqlServerLicenseType: string
sqlVirtualMachineGroupResourceId: string
sqlVirtualMachineName: string
storageConfigurationSettings:
diskConfigurationType: string
sqlDataSettings:
defaultFilePath: string
luns:
- 0
sqlLogSettings:
defaultFilePath: string
luns:
- 0
sqlSystemDbOnDataDisk: false
sqlTempDbSettings:
dataFileCount: 0
dataFileSize: 0
dataGrowth: 0
defaultFilePath: string
logFileSize: 0
logGrowth: 0
luns:
- 0
persistFolder: false
persistFolderPath: string
storageWorkloadType: string
tags:
string: string
virtualMachineResourceId: string
wsfcDomainCredentials:
clusterBootstrapAccountPassword: string
clusterOperatorAccountPassword: string
sqlServiceAccountPassword: string
wsfcStaticIp: string
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:
- Resource
Group stringName - 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 Pulumi.Azure Native. Sql Virtual Machine. Inputs. Assessment Settings - Assessment Settings.
- Auto
Backup Pulumi.Settings Azure Native. Sql Virtual Machine. Inputs. Auto Backup Settings - Auto backup settings for SQL Server.
- Auto
Patching Pulumi.Settings Azure Native. Sql Virtual Machine. Inputs. Auto Patching Settings - Auto patching settings for applying critical security updates to SQL virtual machine.
- Identity
Pulumi.
Azure Native. Sql Virtual Machine. Inputs. Resource Identity - Azure Active Directory identity of the server.
- Key
Vault Pulumi.Credential Settings Azure Native. Sql Virtual Machine. Inputs. Key Vault Credential Settings - Key vault credential settings.
- Location string
- Resource location.
- Server
Configurations Pulumi.Management Settings Azure Native. Sql Virtual Machine. Inputs. Server Configurations Management Settings - SQL Server configuration management settings.
- Sql
Image stringOffer - SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.
- Sql
Image string | Pulumi.Sku Azure Native. Sql Virtual Machine. Sql Image Sku - SQL Server edition type.
- Sql
Management string | Pulumi.Azure Native. Sql Virtual Machine. Sql Management Mode - SQL Server Management type.
- Sql
Server string | Pulumi.License Type Azure Native. Sql Virtual Machine. Sql Server License Type - SQL Server license type.
- Sql
Virtual stringMachine Group Resource Id - ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.
- Sql
Virtual stringMachine Name - Name of the SQL virtual machine.
- Storage
Configuration Pulumi.Settings Azure Native. Sql Virtual Machine. Inputs. Storage Configuration Settings - Storage Configuration Settings.
- Dictionary<string, string>
- Resource tags.
- Virtual
Machine stringResource Id - ARM Resource id of underlying virtual machine created from SQL marketplace image.
- Wsfc
Domain Pulumi.Credentials Azure Native. Sql Virtual Machine. Inputs. Wsfc Domain Credentials - Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
- Wsfc
Static stringIp - Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
- Resource
Group stringName - 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 AssessmentSettings Args - Assessment Settings.
- Auto
Backup AutoSettings Backup Settings Args - Auto backup settings for SQL Server.
- Auto
Patching AutoSettings Patching Settings Args - Auto patching settings for applying critical security updates to SQL virtual machine.
- Identity
Resource
Identity Args - Azure Active Directory identity of the server.
- Key
Vault KeyCredential Settings Vault Credential Settings Args - Key vault credential settings.
- Location string
- Resource location.
- Server
Configurations ServerManagement Settings Configurations Management Settings Args - SQL Server configuration management settings.
- Sql
Image stringOffer - SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.
- Sql
Image string | SqlSku Image Sku - SQL Server edition type.
- Sql
Management string | SqlManagement Mode - SQL Server Management type.
- Sql
Server string | SqlLicense Type Server License Type - SQL Server license type.
- Sql
Virtual stringMachine Group Resource Id - ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.
- Sql
Virtual stringMachine Name - Name of the SQL virtual machine.
- Storage
Configuration StorageSettings Configuration Settings Args - Storage Configuration Settings.
- map[string]string
- Resource tags.
- Virtual
Machine stringResource Id - ARM Resource id of underlying virtual machine created from SQL marketplace image.
- Wsfc
Domain WsfcCredentials Domain Credentials Args - Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
- Wsfc
Static stringIp - Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
- resource
Group StringName - 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 AssessmentSettings - Assessment Settings.
- auto
Backup AutoSettings Backup Settings - Auto backup settings for SQL Server.
- auto
Patching AutoSettings Patching Settings - Auto patching settings for applying critical security updates to SQL virtual machine.
- identity
Resource
Identity - Azure Active Directory identity of the server.
- key
Vault KeyCredential Settings Vault Credential Settings - Key vault credential settings.
- location String
- Resource location.
- server
Configurations ServerManagement Settings Configurations Management Settings - SQL Server configuration management settings.
- sql
Image StringOffer - SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.
- sql
Image String | SqlSku Image Sku - SQL Server edition type.
- sql
Management String | SqlManagement Mode - SQL Server Management type.
- sql
Server String | SqlLicense Type Server License Type - SQL Server license type.
- sql
Virtual StringMachine Group Resource Id - ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.
- sql
Virtual StringMachine Name - Name of the SQL virtual machine.
- storage
Configuration StorageSettings Configuration Settings - Storage Configuration Settings.
- Map<String,String>
- Resource tags.
- virtual
Machine StringResource Id - ARM Resource id of underlying virtual machine created from SQL marketplace image.
- wsfc
Domain WsfcCredentials Domain Credentials - Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
- wsfc
Static StringIp - Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
- resource
Group stringName - 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 AssessmentSettings - Assessment Settings.
- auto
Backup AutoSettings Backup Settings - Auto backup settings for SQL Server.
- auto
Patching AutoSettings Patching Settings - Auto patching settings for applying critical security updates to SQL virtual machine.
- identity
Resource
Identity - Azure Active Directory identity of the server.
- key
Vault KeyCredential Settings Vault Credential Settings - Key vault credential settings.
- location string
- Resource location.
- server
Configurations ServerManagement Settings Configurations Management Settings - SQL Server configuration management settings.
- sql
Image stringOffer - SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.
- sql
Image string | SqlSku Image Sku - SQL Server edition type.
- sql
Management string | SqlManagement Mode - SQL Server Management type.
- sql
Server string | SqlLicense Type Server License Type - SQL Server license type.
- sql
Virtual stringMachine Group Resource Id - ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.
- sql
Virtual stringMachine Name - Name of the SQL virtual machine.
- storage
Configuration StorageSettings Configuration Settings - Storage Configuration Settings.
- {[key: string]: string}
- Resource tags.
- virtual
Machine stringResource Id - ARM Resource id of underlying virtual machine created from SQL marketplace image.
- wsfc
Domain WsfcCredentials Domain Credentials - Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
- wsfc
Static stringIp - Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
- resource_
group_ strname - 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 AssessmentSettings Args - Assessment Settings.
- auto_
backup_ Autosettings Backup Settings Args - Auto backup settings for SQL Server.
- auto_
patching_ Autosettings Patching Settings Args - Auto patching settings for applying critical security updates to SQL virtual machine.
- identity
Resource
Identity Args - Azure Active Directory identity of the server.
- key_
vault_ Keycredential_ settings Vault Credential Settings Args - Key vault credential settings.
- location str
- Resource location.
- server_
configurations_ Servermanagement_ settings Configurations Management Settings Args - SQL Server configuration management settings.
- sql_
image_ stroffer - SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.
- sql_
image_ str | Sqlsku Image Sku - SQL Server edition type.
- sql_
management str | SqlManagement Mode - SQL Server Management type.
- sql_
server_ str | Sqllicense_ type Server License Type - SQL Server license type.
- sql_
virtual_ strmachine_ group_ resource_ id - ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.
- sql_
virtual_ strmachine_ name - Name of the SQL virtual machine.
- storage_
configuration_ Storagesettings Configuration Settings Args - Storage Configuration Settings.
- Mapping[str, str]
- Resource tags.
- virtual_
machine_ strresource_ id - ARM Resource id of underlying virtual machine created from SQL marketplace image.
- wsfc_
domain_ Wsfccredentials Domain Credentials Args - Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
- wsfc_
static_ strip - Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
- resource
Group StringName - 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 Property Map - Assessment Settings.
- auto
Backup Property MapSettings - Auto backup settings for SQL Server.
- auto
Patching Property MapSettings - Auto patching settings for applying critical security updates to SQL virtual machine.
- identity Property Map
- Azure Active Directory identity of the server.
- key
Vault Property MapCredential Settings - Key vault credential settings.
- location String
- Resource location.
- server
Configurations Property MapManagement Settings - SQL Server configuration management settings.
- sql
Image StringOffer - SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.
- sql
Image String | "Developer" | "Express" | "Standard" | "Enterprise" | "Web"Sku - SQL Server edition type.
- sql
Management String | "Full" | "LightWeight" | "No Agent" - SQL Server Management type.
- sql
Server String | "PAYG" | "AHUB" | "DR"License Type - SQL Server license type.
- sql
Virtual StringMachine Group Resource Id - ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.
- sql
Virtual StringMachine Name - Name of the SQL virtual machine.
- storage
Configuration Property MapSettings - Storage Configuration Settings.
- Map<String>
- Resource tags.
- virtual
Machine StringResource Id - ARM Resource id of underlying virtual machine created from SQL marketplace image.
- wsfc
Domain Property MapCredentials - Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
- wsfc
Static StringIp - 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.
- Provisioning
State string - Provisioning state to track the async operation status.
- System
Data Pulumi.Azure Native. Sql Virtual Machine. Outputs. System Data Response - 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.
- Provisioning
State string - Provisioning state to track the async operation status.
- System
Data SystemData Response - 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.
- provisioning
State String - Provisioning state to track the async operation status.
- system
Data SystemData Response - 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.
- provisioning
State string - Provisioning state to track the async operation status.
- system
Data SystemData Response - 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 SystemData Response - 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.
- provisioning
State String - Provisioning state to track the async operation status.
- system
Data Property Map - Metadata pertaining to creation and last modification of the resource.
- type String
- Resource type.
Supporting Types
AdditionalFeaturesServerConfigurations, AdditionalFeaturesServerConfigurationsArgs
- Is
RServices boolEnabled - Enable or disable R services (SQL 2016 onwards).
- Is
RServices boolEnabled - Enable or disable R services (SQL 2016 onwards).
- is
RServices BooleanEnabled - Enable or disable R services (SQL 2016 onwards).
- is
RServices booleanEnabled - Enable or disable R services (SQL 2016 onwards).
- is_
r_ boolservices_ enabled - Enable or disable R services (SQL 2016 onwards).
- is
RServices BooleanEnabled - Enable or disable R services (SQL 2016 onwards).
AdditionalFeaturesServerConfigurationsResponse, AdditionalFeaturesServerConfigurationsResponseArgs
- Is
RServices boolEnabled - Enable or disable R services (SQL 2016 onwards).
- Is
RServices boolEnabled - Enable or disable R services (SQL 2016 onwards).
- is
RServices BooleanEnabled - Enable or disable R services (SQL 2016 onwards).
- is
RServices booleanEnabled - Enable or disable R services (SQL 2016 onwards).
- is_
r_ boolservices_ enabled - Enable or disable R services (SQL 2016 onwards).
- is
RServices BooleanEnabled - Enable or disable R services (SQL 2016 onwards).
AssessmentDayOfWeek, AssessmentDayOfWeekArgs
- Monday
- Monday
- Tuesday
- Tuesday
- Wednesday
- Wednesday
- Thursday
- Thursday
- Friday
- Friday
- Saturday
- Saturday
- Sunday
- Sunday
- Assessment
Day Of Week Monday - Monday
- Assessment
Day Of Week Tuesday - Tuesday
- Assessment
Day Of Week Wednesday - Wednesday
- Assessment
Day Of Week Thursday - Thursday
- Assessment
Day Of Week Friday - Friday
- Assessment
Day Of Week Saturday - Saturday
- Assessment
Day Of Week 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
- "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.
- Run
Immediately bool - Run assessment immediately on SQL virtual machine.
- Schedule
Pulumi.
Azure Native. Sql Virtual Machine. Inputs. 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.
- run
Immediately Boolean - Run assessment immediately on SQL virtual machine.
- schedule Schedule
- Schedule for Assessment.
- enable boolean
- Enable or disable assessment feature on SQL virtual machine.
- run
Immediately 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.
- run
Immediately 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.
- Run
Immediately bool - Run assessment immediately on SQL virtual machine.
- Schedule
Pulumi.
Azure Native. Sql Virtual Machine. Inputs. Schedule Response - 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
Response - Schedule for Assessment.
- enable Boolean
- Enable or disable assessment feature on SQL virtual machine.
- run
Immediately Boolean - Run assessment immediately on SQL virtual machine.
- schedule
Schedule
Response - Schedule for Assessment.
- enable boolean
- Enable or disable assessment feature on SQL virtual machine.
- run
Immediately boolean - Run assessment immediately on SQL virtual machine.
- schedule
Schedule
Response - 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
Response - Schedule for Assessment.
- enable Boolean
- Enable or disable assessment feature on SQL virtual machine.
- run
Immediately 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
- Auto
Backup Days Of Week Monday - Monday
- Auto
Backup Days Of Week Tuesday - Tuesday
- Auto
Backup Days Of Week Wednesday - Wednesday
- Auto
Backup Days Of Week Thursday - Thursday
- Auto
Backup Days Of Week Friday - Friday
- Auto
Backup Days Of Week Saturday - Saturday
- Auto
Backup Days Of Week 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
- "Monday"
- Monday
- "Tuesday"
- Tuesday
- "Wednesday"
- Wednesday
- "Thursday"
- Thursday
- "Friday"
- Friday
- "Saturday"
- Saturday
- "Sunday"
- Sunday
AutoBackupSettings, AutoBackupSettingsArgs
- Backup
Schedule string | Pulumi.Type Azure Native. Sql Virtual Machine. Backup Schedule Type - Backup schedule type.
- Backup
System boolDbs - Include or exclude system databases from auto backup.
- Days
Of List<Union<string, Pulumi.Week Azure Native. Sql Virtual Machine. Auto Backup Days Of Week>> - 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 string | Pulumi.Frequency Azure Native. Sql Virtual Machine. Full Backup Frequency Type - Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
- Full
Backup intStart Time - Start time of a given day during which full backups can take place. 0-23 hours.
- Full
Backup intWindow Hours - Duration of the time window of a given day during which full backups can take place. 1-23 hours.
- Log
Backup intFrequency - Frequency of log backups. 5-60 minutes.
- Password string
- Password for encryption on backup.
- Retention
Period int - Retention period of backup: 1-90 days.
- Storage
Access stringKey - Storage account key where backup will be taken to.
- Storage
Account stringUrl - Storage account url where backup will be taken to.
- Storage
Container stringName - Storage container name where backup will be taken to.
- Backup
Schedule string | BackupType Schedule Type - Backup schedule type.
- Backup
System boolDbs - Include or exclude system databases from auto backup.
- Days
Of []stringWeek - 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 string | FullFrequency Backup Frequency Type - Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
- Full
Backup intStart Time - Start time of a given day during which full backups can take place. 0-23 hours.
- Full
Backup intWindow Hours - Duration of the time window of a given day during which full backups can take place. 1-23 hours.
- Log
Backup intFrequency - Frequency of log backups. 5-60 minutes.
- Password string
- Password for encryption on backup.
- Retention
Period int - Retention period of backup: 1-90 days.
- Storage
Access stringKey - Storage account key where backup will be taken to.
- Storage
Account stringUrl - Storage account url where backup will be taken to.
- Storage
Container stringName - Storage container name where backup will be taken to.
- backup
Schedule String | BackupType Schedule Type - Backup schedule type.
- backup
System BooleanDbs - Include or exclude system databases from auto backup.
- days
Of List<Either<String,AutoWeek Backup Days Of Week>> - Days of the week for the backups when FullBackupFrequency is set to Weekly.
- enable Boolean
- Enable or disable autobackup on SQL virtual machine.
- enable
Encryption Boolean - Enable or disable encryption for backup on SQL virtual machine.
- full
Backup String | FullFrequency Backup Frequency Type - Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
- full
Backup IntegerStart Time - Start time of a given day during which full backups can take place. 0-23 hours.
- full
Backup IntegerWindow Hours - Duration of the time window of a given day during which full backups can take place. 1-23 hours.
- log
Backup IntegerFrequency - Frequency of log backups. 5-60 minutes.
- password String
- Password for encryption on backup.
- retention
Period Integer - Retention period of backup: 1-90 days.
- storage
Access StringKey - Storage account key where backup will be taken to.
- storage
Account StringUrl - Storage account url where backup will be taken to.
- storage
Container StringName - Storage container name where backup will be taken to.
- backup
Schedule string | BackupType Schedule Type - Backup schedule type.
- backup
System booleanDbs - Include or exclude system databases from auto backup.
- days
Of (string | AutoWeek Backup Days Of Week)[] - Days of the week for the backups when FullBackupFrequency is set to Weekly.
- enable boolean
- Enable or disable autobackup on SQL virtual machine.
- enable
Encryption boolean - Enable or disable encryption for backup on SQL virtual machine.
- full
Backup string | FullFrequency Backup Frequency Type - Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
- full
Backup numberStart Time - Start time of a given day during which full backups can take place. 0-23 hours.
- full
Backup numberWindow Hours - Duration of the time window of a given day during which full backups can take place. 1-23 hours.
- log
Backup numberFrequency - Frequency of log backups. 5-60 minutes.
- password string
- Password for encryption on backup.
- retention
Period number - Retention period of backup: 1-90 days.
- storage
Access stringKey - Storage account key where backup will be taken to.
- storage
Account stringUrl - Storage account url where backup will be taken to.
- storage
Container stringName - Storage container name where backup will be taken to.
- backup_
schedule_ str | Backuptype Schedule Type - Backup schedule type.
- backup_
system_ booldbs - Include or exclude system databases from auto backup.
- days_
of_ Sequence[Union[str, Autoweek Backup Days Of Week]] - 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_ str | Fullfrequency Backup Frequency Type - Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
- full_
backup_ intstart_ time - Start time of a given day during which full backups can take place. 0-23 hours.
- full_
backup_ intwindow_ hours - Duration of the time window of a given day during which full backups can take place. 1-23 hours.
- log_
backup_ intfrequency - 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_ strkey - Storage account key where backup will be taken to.
- storage_
account_ strurl - Storage account url where backup will be taken to.
- storage_
container_ strname - Storage container name where backup will be taken to.
- backup
Schedule String | "Manual" | "Automated"Type - Backup schedule type.
- backup
System BooleanDbs - Include or exclude system databases from auto backup.
- days
Of List<String | "Monday" | "Tuesday" | "Wednesday" | "Thursday" | "Friday" | "Saturday" | "Sunday">Week - Days of the week for the backups when FullBackupFrequency is set to Weekly.
- enable Boolean
- Enable or disable autobackup on SQL virtual machine.
- enable
Encryption Boolean - Enable or disable encryption for backup on SQL virtual machine.
- full
Backup String | "Daily" | "Weekly"Frequency - Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
- full
Backup NumberStart Time - Start time of a given day during which full backups can take place. 0-23 hours.
- full
Backup NumberWindow Hours - Duration of the time window of a given day during which full backups can take place. 1-23 hours.
- log
Backup NumberFrequency - Frequency of log backups. 5-60 minutes.
- password String
- Password for encryption on backup.
- retention
Period Number - Retention period of backup: 1-90 days.
- storage
Access StringKey - Storage account key where backup will be taken to.
- storage
Account StringUrl - Storage account url where backup will be taken to.
- storage
Container StringName - Storage container name where backup will be taken to.
AutoBackupSettingsResponse, AutoBackupSettingsResponseArgs
- Backup
Schedule stringType - Backup schedule type.
- Backup
System boolDbs - Include or exclude system databases from auto backup.
- Days
Of List<string>Week - 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 stringFrequency - Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
- Full
Backup intStart Time - Start time of a given day during which full backups can take place. 0-23 hours.
- Full
Backup intWindow Hours - Duration of the time window of a given day during which full backups can take place. 1-23 hours.
- Log
Backup intFrequency - Frequency of log backups. 5-60 minutes.
- Retention
Period int - Retention period of backup: 1-90 days.
- Storage
Account stringUrl - Storage account url where backup will be taken to.
- Storage
Container stringName - Storage container name where backup will be taken to.
- Backup
Schedule stringType - Backup schedule type.
- Backup
System boolDbs - Include or exclude system databases from auto backup.
- Days
Of []stringWeek - 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 stringFrequency - Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
- Full
Backup intStart Time - Start time of a given day during which full backups can take place. 0-23 hours.
- Full
Backup intWindow Hours - Duration of the time window of a given day during which full backups can take place. 1-23 hours.
- Log
Backup intFrequency - Frequency of log backups. 5-60 minutes.
- Retention
Period int - Retention period of backup: 1-90 days.
- Storage
Account stringUrl - Storage account url where backup will be taken to.
- Storage
Container stringName - Storage container name where backup will be taken to.
- backup
Schedule StringType - Backup schedule type.
- backup
System BooleanDbs - Include or exclude system databases from auto backup.
- days
Of List<String>Week - Days of the week for the backups when FullBackupFrequency is set to Weekly.
- enable Boolean
- Enable or disable autobackup on SQL virtual machine.
- enable
Encryption Boolean - Enable or disable encryption for backup on SQL virtual machine.
- full
Backup StringFrequency - Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
- full
Backup IntegerStart Time - Start time of a given day during which full backups can take place. 0-23 hours.
- full
Backup IntegerWindow Hours - Duration of the time window of a given day during which full backups can take place. 1-23 hours.
- log
Backup IntegerFrequency - Frequency of log backups. 5-60 minutes.
- retention
Period Integer - Retention period of backup: 1-90 days.
- storage
Account StringUrl - Storage account url where backup will be taken to.
- storage
Container StringName - Storage container name where backup will be taken to.
- backup
Schedule stringType - Backup schedule type.
- backup
System booleanDbs - Include or exclude system databases from auto backup.
- days
Of string[]Week - Days of the week for the backups when FullBackupFrequency is set to Weekly.
- enable boolean
- Enable or disable autobackup on SQL virtual machine.
- enable
Encryption boolean - Enable or disable encryption for backup on SQL virtual machine.
- full
Backup stringFrequency - Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
- full
Backup numberStart Time - Start time of a given day during which full backups can take place. 0-23 hours.
- full
Backup numberWindow Hours - Duration of the time window of a given day during which full backups can take place. 1-23 hours.
- log
Backup numberFrequency - Frequency of log backups. 5-60 minutes.
- retention
Period number - Retention period of backup: 1-90 days.
- storage
Account stringUrl - Storage account url where backup will be taken to.
- storage
Container stringName - Storage container name where backup will be taken to.
- backup_
schedule_ strtype - Backup schedule type.
- backup_
system_ booldbs - Include or exclude system databases from auto backup.
- days_
of_ Sequence[str]week - 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_ strfrequency - Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
- full_
backup_ intstart_ time - Start time of a given day during which full backups can take place. 0-23 hours.
- full_
backup_ intwindow_ hours - Duration of the time window of a given day during which full backups can take place. 1-23 hours.
- log_
backup_ intfrequency - Frequency of log backups. 5-60 minutes.
- retention_
period int - Retention period of backup: 1-90 days.
- storage_
account_ strurl - Storage account url where backup will be taken to.
- storage_
container_ strname - Storage container name where backup will be taken to.
- backup
Schedule StringType - Backup schedule type.
- backup
System BooleanDbs - Include or exclude system databases from auto backup.
- days
Of List<String>Week - Days of the week for the backups when FullBackupFrequency is set to Weekly.
- enable Boolean
- Enable or disable autobackup on SQL virtual machine.
- enable
Encryption Boolean - Enable or disable encryption for backup on SQL virtual machine.
- full
Backup StringFrequency - Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
- full
Backup NumberStart Time - Start time of a given day during which full backups can take place. 0-23 hours.
- full
Backup NumberWindow Hours - Duration of the time window of a given day during which full backups can take place. 1-23 hours.
- log
Backup NumberFrequency - Frequency of log backups. 5-60 minutes.
- retention
Period Number - Retention period of backup: 1-90 days.
- storage
Account StringUrl - Storage account url where backup will be taken to.
- storage
Container StringName - Storage container name where backup will be taken to.
AutoPatchingSettings, AutoPatchingSettingsArgs
- Day
Of Pulumi.Week Azure Native. Sql Virtual Machine. Day Of Week - Day of week to apply the patch on.
- Enable bool
- Enable or disable autopatching on SQL virtual machine.
- Maintenance
Window intDuration - Duration of patching.
- Maintenance
Window intStarting Hour - Hour of the day when patching is initiated. Local VM time.
- Day
Of DayWeek Of Week - Day of week to apply the patch on.
- Enable bool
- Enable or disable autopatching on SQL virtual machine.
- Maintenance
Window intDuration - Duration of patching.
- Maintenance
Window intStarting Hour - Hour of the day when patching is initiated. Local VM time.
- day
Of DayWeek Of Week - Day of week to apply the patch on.
- enable Boolean
- Enable or disable autopatching on SQL virtual machine.
- maintenance
Window IntegerDuration - Duration of patching.
- maintenance
Window IntegerStarting Hour - Hour of the day when patching is initiated. Local VM time.
- day
Of DayWeek Of Week - Day of week to apply the patch on.
- enable boolean
- Enable or disable autopatching on SQL virtual machine.
- maintenance
Window numberDuration - Duration of patching.
- maintenance
Window numberStarting Hour - Hour of the day when patching is initiated. Local VM time.
- day_
of_ Dayweek Of Week - Day of week to apply the patch on.
- enable bool
- Enable or disable autopatching on SQL virtual machine.
- maintenance_
window_ intduration - Duration of patching.
- maintenance_
window_ intstarting_ hour - Hour of the day when patching is initiated. Local VM time.
- day
Of "Everyday" | "Monday" | "Tuesday" | "Wednesday" | "Thursday" | "Friday" | "Saturday" | "Sunday"Week - Day of week to apply the patch on.
- enable Boolean
- Enable or disable autopatching on SQL virtual machine.
- maintenance
Window NumberDuration - Duration of patching.
- maintenance
Window NumberStarting Hour - Hour of the day when patching is initiated. Local VM time.
AutoPatchingSettingsResponse, AutoPatchingSettingsResponseArgs
- Day
Of stringWeek - Day of week to apply the patch on.
- Enable bool
- Enable or disable autopatching on SQL virtual machine.
- Maintenance
Window intDuration - Duration of patching.
- Maintenance
Window intStarting Hour - Hour of the day when patching is initiated. Local VM time.
- Day
Of stringWeek - Day of week to apply the patch on.
- Enable bool
- Enable or disable autopatching on SQL virtual machine.
- Maintenance
Window intDuration - Duration of patching.
- Maintenance
Window intStarting Hour - Hour of the day when patching is initiated. Local VM time.
- day
Of StringWeek - Day of week to apply the patch on.
- enable Boolean
- Enable or disable autopatching on SQL virtual machine.
- maintenance
Window IntegerDuration - Duration of patching.
- maintenance
Window IntegerStarting Hour - Hour of the day when patching is initiated. Local VM time.
- day
Of stringWeek - Day of week to apply the patch on.
- enable boolean
- Enable or disable autopatching on SQL virtual machine.
- maintenance
Window numberDuration - Duration of patching.
- maintenance
Window numberStarting Hour - Hour of the day when patching is initiated. Local VM time.
- day_
of_ strweek - Day of week to apply the patch on.
- enable bool
- Enable or disable autopatching on SQL virtual machine.
- maintenance_
window_ intduration - Duration of patching.
- maintenance_
window_ intstarting_ hour - Hour of the day when patching is initiated. Local VM time.
- day
Of StringWeek - Day of week to apply the patch on.
- enable Boolean
- Enable or disable autopatching on SQL virtual machine.
- maintenance
Window NumberDuration - Duration of patching.
- maintenance
Window NumberStarting Hour - Hour of the day when patching is initiated. Local VM time.
BackupScheduleType, BackupScheduleTypeArgs
- Manual
- Manual
- Automated
- Automated
- Backup
Schedule Type Manual - Manual
- Backup
Schedule Type Automated - 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
- Connectivity
Type LOCAL - LOCAL
- Connectivity
Type PRIVATE - PRIVATE
- Connectivity
Type PUBLIC - 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
- Day
Of Week Everyday - Everyday
- Day
Of Week Monday - Monday
- Day
Of Week Tuesday - Tuesday
- Day
Of Week Wednesday - Wednesday
- Day
Of Week Thursday - Thursday
- Day
Of Week Friday - Friday
- Day
Of Week Saturday - Saturday
- Day
Of Week 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
- "Everyday"
- Everyday
- "Monday"
- Monday
- "Tuesday"
- Tuesday
- "Wednesday"
- Wednesday
- "Thursday"
- Thursday
- "Friday"
- Friday
- "Saturday"
- Saturday
- "Sunday"
- Sunday
DiskConfigurationType, DiskConfigurationTypeArgs
- NEW
- NEW
- EXTEND
- EXTEND
- ADD
- ADD
- Disk
Configuration Type NEW - NEW
- Disk
Configuration Type EXTEND - EXTEND
- Disk
Configuration Type ADD - 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
- Full
Backup Frequency Type Daily - Daily
- Full
Backup Frequency Type Weekly - Weekly
- Daily
- Daily
- Weekly
- Weekly
- Daily
- Daily
- Weekly
- Weekly
- DAILY
- Daily
- WEEKLY
- Weekly
- "Daily"
- Daily
- "Weekly"
- Weekly
IdentityType, IdentityTypeArgs
- None
- None
- System
Assigned - SystemAssigned
- Identity
Type None - None
- Identity
Type System Assigned - SystemAssigned
- None
- None
- System
Assigned - SystemAssigned
- None
- None
- System
Assigned - SystemAssigned
- NONE
- None
- SYSTEM_ASSIGNED
- SystemAssigned
- "None"
- None
- "System
Assigned" - SystemAssigned
KeyVaultCredentialSettings, KeyVaultCredentialSettingsArgs
- Azure
Key stringVault Url - Azure Key Vault url.
- Credential
Name string - Credential name.
- Enable bool
- Enable or disable key vault credential setting.
- Service
Principal stringName - Service principal name to access key vault.
- Service
Principal stringSecret - Service principal name secret to access key vault.
- Azure
Key stringVault Url - Azure Key Vault url.
- Credential
Name string - Credential name.
- Enable bool
- Enable or disable key vault credential setting.
- Service
Principal stringName - Service principal name to access key vault.
- Service
Principal stringSecret - Service principal name secret to access key vault.
- azure
Key StringVault Url - Azure Key Vault url.
- credential
Name String - Credential name.
- enable Boolean
- Enable or disable key vault credential setting.
- service
Principal StringName - Service principal name to access key vault.
- service
Principal StringSecret - Service principal name secret to access key vault.
- azure
Key stringVault Url - Azure Key Vault url.
- credential
Name string - Credential name.
- enable boolean
- Enable or disable key vault credential setting.
- service
Principal stringName - Service principal name to access key vault.
- service
Principal stringSecret - Service principal name secret to access key vault.
- azure_
key_ strvault_ url - Azure Key Vault url.
- credential_
name str - Credential name.
- enable bool
- Enable or disable key vault credential setting.
- service_
principal_ strname - Service principal name to access key vault.
- service_
principal_ strsecret - Service principal name secret to access key vault.
- azure
Key StringVault Url - Azure Key Vault url.
- credential
Name String - Credential name.
- enable Boolean
- Enable or disable key vault credential setting.
- service
Principal StringName - Service principal name to access key vault.
- service
Principal StringSecret - Service principal name secret to access key vault.
KeyVaultCredentialSettingsResponse, KeyVaultCredentialSettingsResponseArgs
- Azure
Key stringVault Url - Azure Key Vault url.
- Credential
Name string - Credential name.
- Enable bool
- Enable or disable key vault credential setting.
- Service
Principal stringName - Service principal name to access key vault.
- Azure
Key stringVault Url - Azure Key Vault url.
- Credential
Name string - Credential name.
- Enable bool
- Enable or disable key vault credential setting.
- Service
Principal stringName - Service principal name to access key vault.
- azure
Key StringVault Url - Azure Key Vault url.
- credential
Name String - Credential name.
- enable Boolean
- Enable or disable key vault credential setting.
- service
Principal StringName - Service principal name to access key vault.
- azure
Key stringVault Url - Azure Key Vault url.
- credential
Name string - Credential name.
- enable boolean
- Enable or disable key vault credential setting.
- service
Principal stringName - Service principal name to access key vault.
- azure_
key_ strvault_ url - Azure Key Vault url.
- credential_
name str - Credential name.
- enable bool
- Enable or disable key vault credential setting.
- service_
principal_ strname - Service principal name to access key vault.
- azure
Key StringVault Url - Azure Key Vault url.
- credential
Name String - Credential name.
- enable Boolean
- Enable or disable key vault credential setting.
- service
Principal StringName - Service principal name to access key vault.
ResourceIdentity, ResourceIdentityArgs
- Type
string | Pulumi.
Azure Native. Sql Virtual Machine. Identity Type - The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
- Type
string | Identity
Type - The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
- type
String | Identity
Type - The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
- type
string | Identity
Type - The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
- type
str | Identity
Type - 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" | "System
Assigned" - The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
ResourceIdentityResponse, ResourceIdentityResponseArgs
- Principal
Id string - The Azure Active Directory principal id.
- Tenant
Id 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 string - The Azure Active Directory principal id.
- Tenant
Id 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 String - The Azure Active Directory principal id.
- tenant
Id 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 string - The Azure Active Directory principal id.
- tenant
Id 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.
- principal
Id String - The Azure Active Directory principal id.
- tenant
Id 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.
- Is
Ifi boolEnabled - SQL Server IFI.
- Is
Lpim boolEnabled - SQL Server LPIM.
- Is
Optimize boolFor Ad Hoc Workloads Enabled - SQL Server Optimize for Adhoc workloads.
- Max
Dop int - SQL Server MAXDOP.
- Max
Server intMemory MB - SQL Server maximum memory.
- Min
Server intMemory MB - SQL Server minimum memory.
- Collation string
- SQL Server Collation.
- Is
Ifi boolEnabled - SQL Server IFI.
- Is
Lpim boolEnabled - SQL Server LPIM.
- Is
Optimize boolFor Ad Hoc Workloads Enabled - SQL Server Optimize for Adhoc workloads.
- Max
Dop int - SQL Server MAXDOP.
- Max
Server intMemory MB - SQL Server maximum memory.
- Min
Server intMemory MB - SQL Server minimum memory.
- collation String
- SQL Server Collation.
- is
Ifi BooleanEnabled - SQL Server IFI.
- is
Lpim BooleanEnabled - SQL Server LPIM.
- is
Optimize BooleanFor Ad Hoc Workloads Enabled - SQL Server Optimize for Adhoc workloads.
- max
Dop Integer - SQL Server MAXDOP.
- max
Server IntegerMemory MB - SQL Server maximum memory.
- min
Server IntegerMemory MB - SQL Server minimum memory.
- collation string
- SQL Server Collation.
- is
Ifi booleanEnabled - SQL Server IFI.
- is
Lpim booleanEnabled - SQL Server LPIM.
- is
Optimize booleanFor Ad Hoc Workloads Enabled - SQL Server Optimize for Adhoc workloads.
- max
Dop number - SQL Server MAXDOP.
- max
Server numberMemory MB - SQL Server maximum memory.
- min
Server numberMemory MB - SQL Server minimum memory.
- collation str
- SQL Server Collation.
- is_
ifi_ boolenabled - SQL Server IFI.
- is_
lpim_ boolenabled - SQL Server LPIM.
- is_
optimize_ boolfor_ ad_ hoc_ workloads_ enabled - SQL Server Optimize for Adhoc workloads.
- max_
dop int - SQL Server MAXDOP.
- max_
server_ intmemory_ mb - SQL Server maximum memory.
- min_
server_ intmemory_ mb - SQL Server minimum memory.
- collation String
- SQL Server Collation.
- is
Ifi BooleanEnabled - SQL Server IFI.
- is
Lpim BooleanEnabled - SQL Server LPIM.
- is
Optimize BooleanFor Ad Hoc Workloads Enabled - SQL Server Optimize for Adhoc workloads.
- max
Dop Number - SQL Server MAXDOP.
- max
Server NumberMemory MB - SQL Server maximum memory.
- min
Server NumberMemory MB - SQL Server minimum memory.
SQLInstanceSettingsResponse, SQLInstanceSettingsResponseArgs
- Collation string
- SQL Server Collation.
- Is
Ifi boolEnabled - SQL Server IFI.
- Is
Lpim boolEnabled - SQL Server LPIM.
- Is
Optimize boolFor Ad Hoc Workloads Enabled - SQL Server Optimize for Adhoc workloads.
- Max
Dop int - SQL Server MAXDOP.
- Max
Server intMemory MB - SQL Server maximum memory.
- Min
Server intMemory MB - SQL Server minimum memory.
- Collation string
- SQL Server Collation.
- Is
Ifi boolEnabled - SQL Server IFI.
- Is
Lpim boolEnabled - SQL Server LPIM.
- Is
Optimize boolFor Ad Hoc Workloads Enabled - SQL Server Optimize for Adhoc workloads.
- Max
Dop int - SQL Server MAXDOP.
- Max
Server intMemory MB - SQL Server maximum memory.
- Min
Server intMemory MB - SQL Server minimum memory.
- collation String
- SQL Server Collation.
- is
Ifi BooleanEnabled - SQL Server IFI.
- is
Lpim BooleanEnabled - SQL Server LPIM.
- is
Optimize BooleanFor Ad Hoc Workloads Enabled - SQL Server Optimize for Adhoc workloads.
- max
Dop Integer - SQL Server MAXDOP.
- max
Server IntegerMemory MB - SQL Server maximum memory.
- min
Server IntegerMemory MB - SQL Server minimum memory.
- collation string
- SQL Server Collation.
- is
Ifi booleanEnabled - SQL Server IFI.
- is
Lpim booleanEnabled - SQL Server LPIM.
- is
Optimize booleanFor Ad Hoc Workloads Enabled - SQL Server Optimize for Adhoc workloads.
- max
Dop number - SQL Server MAXDOP.
- max
Server numberMemory MB - SQL Server maximum memory.
- min
Server numberMemory MB - SQL Server minimum memory.
- collation str
- SQL Server Collation.
- is_
ifi_ boolenabled - SQL Server IFI.
- is_
lpim_ boolenabled - SQL Server LPIM.
- is_
optimize_ boolfor_ ad_ hoc_ workloads_ enabled - SQL Server Optimize for Adhoc workloads.
- max_
dop int - SQL Server MAXDOP.
- max_
server_ intmemory_ mb - SQL Server maximum memory.
- min_
server_ intmemory_ mb - SQL Server minimum memory.
- collation String
- SQL Server Collation.
- is
Ifi BooleanEnabled - SQL Server IFI.
- is
Lpim BooleanEnabled - SQL Server LPIM.
- is
Optimize BooleanFor Ad Hoc Workloads Enabled - SQL Server Optimize for Adhoc workloads.
- max
Dop Number - SQL Server MAXDOP.
- max
Server NumberMemory MB - SQL Server maximum memory.
- min
Server NumberMemory MB - SQL Server minimum memory.
SQLStorageSettings, SQLStorageSettingsArgs
- Default
File stringPath - SQL Server default file path
- Luns List<int>
- Logical Unit Numbers for the disks.
- Default
File stringPath - SQL Server default file path
- Luns []int
- Logical Unit Numbers for the disks.
- default
File StringPath - SQL Server default file path
- luns List<Integer>
- Logical Unit Numbers for the disks.
- default
File stringPath - SQL Server default file path
- luns number[]
- Logical Unit Numbers for the disks.
- default_
file_ strpath - SQL Server default file path
- luns Sequence[int]
- Logical Unit Numbers for the disks.
- default
File StringPath - SQL Server default file path
- luns List<Number>
- Logical Unit Numbers for the disks.
SQLStorageSettingsResponse, SQLStorageSettingsResponseArgs
- Default
File stringPath - SQL Server default file path
- Luns List<int>
- Logical Unit Numbers for the disks.
- Default
File stringPath - SQL Server default file path
- Luns []int
- Logical Unit Numbers for the disks.
- default
File StringPath - SQL Server default file path
- luns List<Integer>
- Logical Unit Numbers for the disks.
- default
File stringPath - SQL Server default file path
- luns number[]
- Logical Unit Numbers for the disks.
- default_
file_ strpath - SQL Server default file path
- luns Sequence[int]
- Logical Unit Numbers for the disks.
- default
File StringPath - SQL Server default file path
- luns List<Number>
- Logical Unit Numbers for the disks.
SQLTempDbSettings, SQLTempDbSettingsArgs
- Data
File intCount - SQL Server tempdb data file count
- Data
File intSize - SQL Server tempdb data file size
- Data
Growth int - SQL Server tempdb data file autoGrowth size
- Default
File stringPath - SQL Server default file path
- Log
File intSize - SQL Server tempdb log file size
- Log
Growth int - SQL Server tempdb log file autoGrowth size
- Luns List<int>
- Logical Unit Numbers for the disks.
- Persist
Folder bool - SQL Server tempdb persist folder choice
- Persist
Folder stringPath - SQL Server tempdb persist folder location
- Data
File intCount - SQL Server tempdb data file count
- Data
File intSize - SQL Server tempdb data file size
- Data
Growth int - SQL Server tempdb data file autoGrowth size
- Default
File stringPath - SQL Server default file path
- Log
File intSize - SQL Server tempdb log file size
- Log
Growth int - SQL Server tempdb log file autoGrowth size
- Luns []int
- Logical Unit Numbers for the disks.
- Persist
Folder bool - SQL Server tempdb persist folder choice
- Persist
Folder stringPath - SQL Server tempdb persist folder location
- data
File IntegerCount - SQL Server tempdb data file count
- data
File IntegerSize - SQL Server tempdb data file size
- data
Growth Integer - SQL Server tempdb data file autoGrowth size
- default
File StringPath - SQL Server default file path
- log
File IntegerSize - SQL Server tempdb log file size
- log
Growth Integer - SQL Server tempdb log file autoGrowth size
- luns List<Integer>
- Logical Unit Numbers for the disks.
- persist
Folder Boolean - SQL Server tempdb persist folder choice
- persist
Folder StringPath - SQL Server tempdb persist folder location
- data
File numberCount - SQL Server tempdb data file count
- data
File numberSize - SQL Server tempdb data file size
- data
Growth number - SQL Server tempdb data file autoGrowth size
- default
File stringPath - SQL Server default file path
- log
File numberSize - SQL Server tempdb log file size
- log
Growth number - SQL Server tempdb log file autoGrowth size
- luns number[]
- Logical Unit Numbers for the disks.
- persist
Folder boolean - SQL Server tempdb persist folder choice
- persist
Folder stringPath - SQL Server tempdb persist folder location
- data_
file_ intcount - SQL Server tempdb data file count
- data_
file_ intsize - SQL Server tempdb data file size
- data_
growth int - SQL Server tempdb data file autoGrowth size
- default_
file_ strpath - SQL Server default file path
- log_
file_ intsize - 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_ strpath - SQL Server tempdb persist folder location
- data
File NumberCount - SQL Server tempdb data file count
- data
File NumberSize - SQL Server tempdb data file size
- data
Growth Number - SQL Server tempdb data file autoGrowth size
- default
File StringPath - SQL Server default file path
- log
File NumberSize - SQL Server tempdb log file size
- log
Growth Number - SQL Server tempdb log file autoGrowth size
- luns List<Number>
- Logical Unit Numbers for the disks.
- persist
Folder Boolean - SQL Server tempdb persist folder choice
- persist
Folder StringPath - SQL Server tempdb persist folder location
SQLTempDbSettingsResponse, SQLTempDbSettingsResponseArgs
- Data
File intCount - SQL Server tempdb data file count
- Data
File intSize - SQL Server tempdb data file size
- Data
Growth int - SQL Server tempdb data file autoGrowth size
- Default
File stringPath - SQL Server default file path
- Log
File intSize - SQL Server tempdb log file size
- Log
Growth int - SQL Server tempdb log file autoGrowth size
- Luns List<int>
- Logical Unit Numbers for the disks.
- Persist
Folder bool - SQL Server tempdb persist folder choice
- Persist
Folder stringPath - SQL Server tempdb persist folder location
- Data
File intCount - SQL Server tempdb data file count
- Data
File intSize - SQL Server tempdb data file size
- Data
Growth int - SQL Server tempdb data file autoGrowth size
- Default
File stringPath - SQL Server default file path
- Log
File intSize - SQL Server tempdb log file size
- Log
Growth int - SQL Server tempdb log file autoGrowth size
- Luns []int
- Logical Unit Numbers for the disks.
- Persist
Folder bool - SQL Server tempdb persist folder choice
- Persist
Folder stringPath - SQL Server tempdb persist folder location
- data
File IntegerCount - SQL Server tempdb data file count
- data
File IntegerSize - SQL Server tempdb data file size
- data
Growth Integer - SQL Server tempdb data file autoGrowth size
- default
File StringPath - SQL Server default file path
- log
File IntegerSize - SQL Server tempdb log file size
- log
Growth Integer - SQL Server tempdb log file autoGrowth size
- luns List<Integer>
- Logical Unit Numbers for the disks.
- persist
Folder Boolean - SQL Server tempdb persist folder choice
- persist
Folder StringPath - SQL Server tempdb persist folder location
- data
File numberCount - SQL Server tempdb data file count
- data
File numberSize - SQL Server tempdb data file size
- data
Growth number - SQL Server tempdb data file autoGrowth size
- default
File stringPath - SQL Server default file path
- log
File numberSize - SQL Server tempdb log file size
- log
Growth number - SQL Server tempdb log file autoGrowth size
- luns number[]
- Logical Unit Numbers for the disks.
- persist
Folder boolean - SQL Server tempdb persist folder choice
- persist
Folder stringPath - SQL Server tempdb persist folder location
- data_
file_ intcount - SQL Server tempdb data file count
- data_
file_ intsize - SQL Server tempdb data file size
- data_
growth int - SQL Server tempdb data file autoGrowth size
- default_
file_ strpath - SQL Server default file path
- log_
file_ intsize - 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_ strpath - SQL Server tempdb persist folder location
- data
File NumberCount - SQL Server tempdb data file count
- data
File NumberSize - SQL Server tempdb data file size
- data
Growth Number - SQL Server tempdb data file autoGrowth size
- default
File StringPath - SQL Server default file path
- log
File NumberSize - SQL Server tempdb log file size
- log
Growth Number - SQL Server tempdb log file autoGrowth size
- luns List<Number>
- Logical Unit Numbers for the disks.
- persist
Folder Boolean - SQL Server tempdb persist folder choice
- persist
Folder StringPath - SQL Server tempdb persist folder location
Schedule, ScheduleArgs
- Day
Of Pulumi.Week Azure Native. Sql Virtual Machine. Assessment Day Of Week - 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 string - 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
- Day
Of AssessmentWeek Day Of Week - 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 string - 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
- day
Of AssessmentWeek Day Of Week - Day of the week to run assessment.
- enable Boolean
- Enable or disable assessment schedule on SQL virtual machine.
- monthly
Occurrence 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
- start
Time String - Time of the day in HH:mm format. Eg. 17:30
- weekly
Interval Integer - Number of weeks to schedule between 2 assessment runs. Takes value from 1-6
- day
Of AssessmentWeek Day Of Week - Day of the week to run assessment.
- enable boolean
- Enable or disable assessment schedule on SQL virtual machine.
- monthly
Occurrence 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
- start
Time string - Time of the day in HH:mm format. Eg. 17:30
- weekly
Interval number - Number of weeks to schedule between 2 assessment runs. Takes value from 1-6
- day_
of_ Assessmentweek Day Of Week - 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
- day
Of "Monday" | "Tuesday" | "Wednesday" | "Thursday" | "Friday" | "Saturday" | "Sunday"Week - Day of the week to run assessment.
- enable Boolean
- Enable or disable assessment schedule on SQL virtual machine.
- monthly
Occurrence 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
- start
Time String - Time of the day in HH:mm format. Eg. 17:30
- weekly
Interval Number - Number of weeks to schedule between 2 assessment runs. Takes value from 1-6
ScheduleResponse, ScheduleResponseArgs
- Day
Of stringWeek - 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 string - 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
- Day
Of stringWeek - 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 string - 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
- day
Of StringWeek - Day of the week to run assessment.
- enable Boolean
- Enable or disable assessment schedule on SQL virtual machine.
- monthly
Occurrence 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
- start
Time String - Time of the day in HH:mm format. Eg. 17:30
- weekly
Interval Integer - Number of weeks to schedule between 2 assessment runs. Takes value from 1-6
- day
Of stringWeek - Day of the week to run assessment.
- enable boolean
- Enable or disable assessment schedule on SQL virtual machine.
- monthly
Occurrence 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
- start
Time string - Time of the day in HH:mm format. Eg. 17:30
- weekly
Interval number - Number of weeks to schedule between 2 assessment runs. Takes value from 1-6
- day_
of_ strweek - 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
- day
Of StringWeek - Day of the week to run assessment.
- enable Boolean
- Enable or disable assessment schedule on SQL virtual machine.
- monthly
Occurrence 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
- start
Time String - Time of the day in HH:mm format. Eg. 17:30
- weekly
Interval Number - Number of weeks to schedule between 2 assessment runs. Takes value from 1-6
ServerConfigurationsManagementSettings, ServerConfigurationsManagementSettingsArgs
- Additional
Features Pulumi.Server Configurations Azure Native. Sql Virtual Machine. Inputs. Additional Features Server Configurations - Additional SQL feature settings.
- Sql
Connectivity Pulumi.Update Settings Azure Native. Sql Virtual Machine. Inputs. Sql Connectivity Update Settings - SQL connectivity type settings.
- Sql
Instance Pulumi.Settings Azure Native. Sql Virtual Machine. Inputs. SQLInstance Settings - SQL Instance settings.
- Sql
Storage Pulumi.Update Settings Azure Native. Sql Virtual Machine. Inputs. Sql Storage Update Settings - SQL storage update settings.
- Sql
Workload Pulumi.Type Update Settings Azure Native. Sql Virtual Machine. Inputs. Sql Workload Type Update Settings - SQL workload type settings.
- Additional
Features AdditionalServer Configurations Features Server Configurations - Additional SQL feature settings.
- Sql
Connectivity SqlUpdate Settings Connectivity Update Settings - SQL connectivity type settings.
- Sql
Instance SQLInstanceSettings Settings - SQL Instance settings.
- Sql
Storage SqlUpdate Settings Storage Update Settings - SQL storage update settings.
- Sql
Workload SqlType Update Settings Workload Type Update Settings - SQL workload type settings.
- additional
Features AdditionalServer Configurations Features Server Configurations - Additional SQL feature settings.
- sql
Connectivity SqlUpdate Settings Connectivity Update Settings - SQL connectivity type settings.
- sql
Instance SQLInstanceSettings Settings - SQL Instance settings.
- sql
Storage SqlUpdate Settings Storage Update Settings - SQL storage update settings.
- sql
Workload SqlType Update Settings Workload Type Update Settings - SQL workload type settings.
- additional
Features AdditionalServer Configurations Features Server Configurations - Additional SQL feature settings.
- sql
Connectivity SqlUpdate Settings Connectivity Update Settings - SQL connectivity type settings.
- sql
Instance SQLInstanceSettings Settings - SQL Instance settings.
- sql
Storage SqlUpdate Settings Storage Update Settings - SQL storage update settings.
- sql
Workload SqlType Update Settings Workload Type Update Settings - SQL workload type settings.
- additional_
features_ Additionalserver_ configurations Features Server Configurations - Additional SQL feature settings.
- sql_
connectivity_ Sqlupdate_ settings Connectivity Update Settings - SQL connectivity type settings.
- sql_
instance_ SQLInstancesettings Settings - SQL Instance settings.
- sql_
storage_ Sqlupdate_ settings Storage Update Settings - SQL storage update settings.
- sql_
workload_ Sqltype_ update_ settings Workload Type Update Settings - SQL workload type settings.
- additional
Features Property MapServer Configurations - Additional SQL feature settings.
- sql
Connectivity Property MapUpdate Settings - SQL connectivity type settings.
- sql
Instance Property MapSettings - SQL Instance settings.
- sql
Storage Property MapUpdate Settings - SQL storage update settings.
- sql
Workload Property MapType Update Settings - SQL workload type settings.
ServerConfigurationsManagementSettingsResponse, ServerConfigurationsManagementSettingsResponseArgs
- Additional
Features Pulumi.Server Configurations Azure Native. Sql Virtual Machine. Inputs. Additional Features Server Configurations Response - Additional SQL feature settings.
- Sql
Connectivity Pulumi.Update Settings Azure Native. Sql Virtual Machine. Inputs. Sql Connectivity Update Settings Response - SQL connectivity type settings.
- Sql
Instance Pulumi.Settings Azure Native. Sql Virtual Machine. Inputs. SQLInstance Settings Response - SQL Instance settings.
- Sql
Storage Pulumi.Update Settings Azure Native. Sql Virtual Machine. Inputs. Sql Storage Update Settings Response - SQL storage update settings.
- Sql
Workload Pulumi.Type Update Settings Azure Native. Sql Virtual Machine. Inputs. Sql Workload Type Update Settings Response - SQL workload type settings.
- Additional
Features AdditionalServer Configurations Features Server Configurations Response - Additional SQL feature settings.
- Sql
Connectivity SqlUpdate Settings Connectivity Update Settings Response - SQL connectivity type settings.
- Sql
Instance SQLInstanceSettings Settings Response - SQL Instance settings.
- Sql
Storage SqlUpdate Settings Storage Update Settings Response - SQL storage update settings.
- Sql
Workload SqlType Update Settings Workload Type Update Settings Response - SQL workload type settings.
- additional
Features AdditionalServer Configurations Features Server Configurations Response - Additional SQL feature settings.
- sql
Connectivity SqlUpdate Settings Connectivity Update Settings Response - SQL connectivity type settings.
- sql
Instance SQLInstanceSettings Settings Response - SQL Instance settings.
- sql
Storage SqlUpdate Settings Storage Update Settings Response - SQL storage update settings.
- sql
Workload SqlType Update Settings Workload Type Update Settings Response - SQL workload type settings.
- additional
Features AdditionalServer Configurations Features Server Configurations Response - Additional SQL feature settings.
- sql
Connectivity SqlUpdate Settings Connectivity Update Settings Response - SQL connectivity type settings.
- sql
Instance SQLInstanceSettings Settings Response - SQL Instance settings.
- sql
Storage SqlUpdate Settings Storage Update Settings Response - SQL storage update settings.
- sql
Workload SqlType Update Settings Workload Type Update Settings Response - SQL workload type settings.
- additional_
features_ Additionalserver_ configurations Features Server Configurations Response - Additional SQL feature settings.
- sql_
connectivity_ Sqlupdate_ settings Connectivity Update Settings Response - SQL connectivity type settings.
- sql_
instance_ SQLInstancesettings Settings Response - SQL Instance settings.
- sql_
storage_ Sqlupdate_ settings Storage Update Settings Response - SQL storage update settings.
- sql_
workload_ Sqltype_ update_ settings Workload Type Update Settings Response - SQL workload type settings.
- additional
Features Property MapServer Configurations - Additional SQL feature settings.
- sql
Connectivity Property MapUpdate Settings - SQL connectivity type settings.
- sql
Instance Property MapSettings - SQL Instance settings.
- sql
Storage Property MapUpdate Settings - SQL storage update settings.
- sql
Workload Property MapType Update Settings - SQL workload type settings.
SqlConnectivityUpdateSettings, SqlConnectivityUpdateSettingsArgs
- Connectivity
Type string | Pulumi.Azure Native. Sql Virtual Machine. Connectivity Type - SQL Server connectivity option.
- Port int
- SQL Server port.
- Sql
Auth stringUpdate Password - SQL Server sysadmin login password.
- Sql
Auth stringUpdate User Name - SQL Server sysadmin login to create.
- Connectivity
Type string | ConnectivityType - SQL Server connectivity option.
- Port int
- SQL Server port.
- Sql
Auth stringUpdate Password - SQL Server sysadmin login password.
- Sql
Auth stringUpdate User Name - SQL Server sysadmin login to create.
- connectivity
Type String | ConnectivityType - SQL Server connectivity option.
- port Integer
- SQL Server port.
- sql
Auth StringUpdate Password - SQL Server sysadmin login password.
- sql
Auth StringUpdate User Name - SQL Server sysadmin login to create.
- connectivity
Type string | ConnectivityType - SQL Server connectivity option.
- port number
- SQL Server port.
- sql
Auth stringUpdate Password - SQL Server sysadmin login password.
- sql
Auth stringUpdate User Name - SQL Server sysadmin login to create.
- connectivity_
type str | ConnectivityType - SQL Server connectivity option.
- port int
- SQL Server port.
- sql_
auth_ strupdate_ password - SQL Server sysadmin login password.
- sql_
auth_ strupdate_ user_ name - SQL Server sysadmin login to create.
- connectivity
Type String | "LOCAL" | "PRIVATE" | "PUBLIC" - SQL Server connectivity option.
- port Number
- SQL Server port.
- sql
Auth StringUpdate Password - SQL Server sysadmin login password.
- sql
Auth StringUpdate User Name - SQL Server sysadmin login to create.
SqlConnectivityUpdateSettingsResponse, SqlConnectivityUpdateSettingsResponseArgs
- Connectivity
Type string - SQL Server connectivity option.
- Port int
- SQL Server port.
- Connectivity
Type string - SQL Server connectivity option.
- Port int
- SQL Server port.
- connectivity
Type String - SQL Server connectivity option.
- port Integer
- SQL Server port.
- connectivity
Type string - SQL Server connectivity option.
- port number
- SQL Server port.
- connectivity_
type str - SQL Server connectivity option.
- port int
- SQL Server port.
- connectivity
Type String - SQL Server connectivity option.
- port Number
- SQL Server port.
SqlImageSku, SqlImageSkuArgs
- Developer
- Developer
- Express
- Express
- Standard
- Standard
- Enterprise
- Enterprise
- Web
- Web
- Sql
Image Sku Developer - Developer
- Sql
Image Sku Express - Express
- Sql
Image Sku Standard - Standard
- Sql
Image Sku Enterprise - Enterprise
- Sql
Image Sku 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
- "Developer"
- Developer
- "Express"
- Express
- "Standard"
- Standard
- "Enterprise"
- Enterprise
- "Web"
- Web
SqlManagementMode, SqlManagementModeArgs
- Full
- Full
- Light
Weight - LightWeight
- No
Agent - NoAgent
- Sql
Management Mode Full - Full
- Sql
Management Mode Light Weight - LightWeight
- Sql
Management Mode No Agent - NoAgent
- Full
- Full
- Light
Weight - LightWeight
- No
Agent - NoAgent
- Full
- Full
- Light
Weight - LightWeight
- No
Agent - NoAgent
- FULL
- Full
- LIGHT_WEIGHT
- LightWeight
- NO_AGENT
- NoAgent
- "Full"
- Full
- "Light
Weight" - LightWeight
- "No
Agent" - NoAgent
SqlServerLicenseType, SqlServerLicenseTypeArgs
- PAYG
- PAYG
- AHUB
- AHUB
- DR
- DR
- Sql
Server License Type PAYG - PAYG
- Sql
Server License Type AHUB - AHUB
- Sql
Server License Type DR - 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
- Disk
Configuration string | Pulumi.Type Azure Native. Sql Virtual Machine. Disk Configuration Type - Disk configuration to apply to SQL Server.
- Disk
Count int - Virtual machine disk count.
- Starting
Device intId - Device id of the first disk to be updated.
- Disk
Configuration string | DiskType Configuration Type - Disk configuration to apply to SQL Server.
- Disk
Count int - Virtual machine disk count.
- Starting
Device intId - Device id of the first disk to be updated.
- disk
Configuration String | DiskType Configuration Type - Disk configuration to apply to SQL Server.
- disk
Count Integer - Virtual machine disk count.
- starting
Device IntegerId - Device id of the first disk to be updated.
- disk
Configuration string | DiskType Configuration Type - Disk configuration to apply to SQL Server.
- disk
Count number - Virtual machine disk count.
- starting
Device numberId - Device id of the first disk to be updated.
- disk_
configuration_ str | Disktype Configuration Type - Disk configuration to apply to SQL Server.
- disk_
count int - Virtual machine disk count.
- starting_
device_ intid - Device id of the first disk to be updated.
- disk
Configuration String | "NEW" | "EXTEND" | "ADD"Type - Disk configuration to apply to SQL Server.
- disk
Count Number - Virtual machine disk count.
- starting
Device NumberId - Device id of the first disk to be updated.
SqlStorageUpdateSettingsResponse, SqlStorageUpdateSettingsResponseArgs
- Disk
Configuration stringType - Disk configuration to apply to SQL Server.
- Disk
Count int - Virtual machine disk count.
- Starting
Device intId - Device id of the first disk to be updated.
- Disk
Configuration stringType - Disk configuration to apply to SQL Server.
- Disk
Count int - Virtual machine disk count.
- Starting
Device intId - Device id of the first disk to be updated.
- disk
Configuration StringType - Disk configuration to apply to SQL Server.
- disk
Count Integer - Virtual machine disk count.
- starting
Device IntegerId - Device id of the first disk to be updated.
- disk
Configuration stringType - Disk configuration to apply to SQL Server.
- disk
Count number - Virtual machine disk count.
- starting
Device numberId - Device id of the first disk to be updated.
- disk_
configuration_ strtype - Disk configuration to apply to SQL Server.
- disk_
count int - Virtual machine disk count.
- starting_
device_ intid - Device id of the first disk to be updated.
- disk
Configuration StringType - Disk configuration to apply to SQL Server.
- disk
Count Number - Virtual machine disk count.
- starting
Device NumberId - Device id of the first disk to be updated.
SqlWorkloadType, SqlWorkloadTypeArgs
- GENERAL
- GENERAL
- OLTP
- OLTP
- DW
- DW
- Sql
Workload Type GENERAL - GENERAL
- Sql
Workload Type OLTP - OLTP
- Sql
Workload Type DW - 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
- Sql
Workload string | Pulumi.Type Azure Native. Sql Virtual Machine. Sql Workload Type - SQL Server workload type.
- Sql
Workload string | SqlType Workload Type - SQL Server workload type.
- sql
Workload String | SqlType Workload Type - SQL Server workload type.
- sql
Workload string | SqlType Workload Type - SQL Server workload type.
- sql_
workload_ str | Sqltype Workload Type - SQL Server workload type.
- sql
Workload String | "GENERAL" | "OLTP" | "DW"Type - SQL Server workload type.
SqlWorkloadTypeUpdateSettingsResponse, SqlWorkloadTypeUpdateSettingsResponseArgs
- Sql
Workload stringType - SQL Server workload type.
- Sql
Workload stringType - SQL Server workload type.
- sql
Workload StringType - SQL Server workload type.
- sql
Workload stringType - SQL Server workload type.
- sql_
workload_ strtype - SQL Server workload type.
- sql
Workload StringType - SQL Server workload type.
StorageConfigurationSettings, StorageConfigurationSettingsArgs
- Disk
Configuration string | Pulumi.Type Azure Native. Sql Virtual Machine. Disk Configuration Type - Disk configuration to apply to SQL Server.
- Sql
Data Pulumi.Settings Azure Native. Sql Virtual Machine. Inputs. SQLStorage Settings - SQL Server Data Storage Settings.
- Sql
Log Pulumi.Settings Azure Native. Sql Virtual Machine. Inputs. SQLStorage Settings - SQL Server Log Storage Settings.
- Sql
System boolDb On Data Disk - SQL Server SystemDb Storage on DataPool if true.
- Sql
Temp Pulumi.Db Settings Azure Native. Sql Virtual Machine. Inputs. SQLTemp Db Settings - SQL Server TempDb Storage Settings.
- Storage
Workload string | Pulumi.Type Azure Native. Sql Virtual Machine. Storage Workload Type - Storage workload type.
- Disk
Configuration string | DiskType Configuration Type - Disk configuration to apply to SQL Server.
- Sql
Data SQLStorageSettings Settings - SQL Server Data Storage Settings.
- Sql
Log SQLStorageSettings Settings - SQL Server Log Storage Settings.
- Sql
System boolDb On Data Disk - SQL Server SystemDb Storage on DataPool if true.
- Sql
Temp SQLTempDb Settings Db Settings - SQL Server TempDb Storage Settings.
- Storage
Workload string | StorageType Workload Type - Storage workload type.
- disk
Configuration String | DiskType Configuration Type - Disk configuration to apply to SQL Server.
- sql
Data SQLStorageSettings Settings - SQL Server Data Storage Settings.
- sql
Log SQLStorageSettings Settings - SQL Server Log Storage Settings.
- sql
System BooleanDb On Data Disk - SQL Server SystemDb Storage on DataPool if true.
- sql
Temp SQLTempDb Settings Db Settings - SQL Server TempDb Storage Settings.
- storage
Workload String | StorageType Workload Type - Storage workload type.
- disk
Configuration string | DiskType Configuration Type - Disk configuration to apply to SQL Server.
- sql
Data SQLStorageSettings Settings - SQL Server Data Storage Settings.
- sql
Log SQLStorageSettings Settings - SQL Server Log Storage Settings.
- sql
System booleanDb On Data Disk - SQL Server SystemDb Storage on DataPool if true.
- sql
Temp SQLTempDb Settings Db Settings - SQL Server TempDb Storage Settings.
- storage
Workload string | StorageType Workload Type - Storage workload type.
- disk_
configuration_ str | Disktype Configuration Type - Disk configuration to apply to SQL Server.
- sql_
data_ SQLStoragesettings Settings - SQL Server Data Storage Settings.
- sql_
log_ SQLStoragesettings Settings - SQL Server Log Storage Settings.
- sql_
system_ booldb_ on_ data_ disk - SQL Server SystemDb Storage on DataPool if true.
- sql_
temp_ SQLTempdb_ settings Db Settings - SQL Server TempDb Storage Settings.
- storage_
workload_ str | Storagetype Workload Type - Storage workload type.
- disk
Configuration String | "NEW" | "EXTEND" | "ADD"Type - Disk configuration to apply to SQL Server.
- sql
Data Property MapSettings - SQL Server Data Storage Settings.
- sql
Log Property MapSettings - SQL Server Log Storage Settings.
- sql
System BooleanDb On Data Disk - SQL Server SystemDb Storage on DataPool if true.
- sql
Temp Property MapDb Settings - SQL Server TempDb Storage Settings.
- storage
Workload String | "GENERAL" | "OLTP" | "DW"Type - Storage workload type.
StorageConfigurationSettingsResponse, StorageConfigurationSettingsResponseArgs
- Disk
Configuration stringType - Disk configuration to apply to SQL Server.
- Sql
Data Pulumi.Settings Azure Native. Sql Virtual Machine. Inputs. SQLStorage Settings Response - SQL Server Data Storage Settings.
- Sql
Log Pulumi.Settings Azure Native. Sql Virtual Machine. Inputs. SQLStorage Settings Response - SQL Server Log Storage Settings.
- Sql
System boolDb On Data Disk - SQL Server SystemDb Storage on DataPool if true.
- Sql
Temp Pulumi.Db Settings Azure Native. Sql Virtual Machine. Inputs. SQLTemp Db Settings Response - SQL Server TempDb Storage Settings.
- Storage
Workload stringType - Storage workload type.
- Disk
Configuration stringType - Disk configuration to apply to SQL Server.
- Sql
Data SQLStorageSettings Settings Response - SQL Server Data Storage Settings.
- Sql
Log SQLStorageSettings Settings Response - SQL Server Log Storage Settings.
- Sql
System boolDb On Data Disk - SQL Server SystemDb Storage on DataPool if true.
- Sql
Temp SQLTempDb Settings Db Settings Response - SQL Server TempDb Storage Settings.
- Storage
Workload stringType - Storage workload type.
- disk
Configuration StringType - Disk configuration to apply to SQL Server.
- sql
Data SQLStorageSettings Settings Response - SQL Server Data Storage Settings.
- sql
Log SQLStorageSettings Settings Response - SQL Server Log Storage Settings.
- sql
System BooleanDb On Data Disk - SQL Server SystemDb Storage on DataPool if true.
- sql
Temp SQLTempDb Settings Db Settings Response - SQL Server TempDb Storage Settings.
- storage
Workload StringType - Storage workload type.
- disk
Configuration stringType - Disk configuration to apply to SQL Server.
- sql
Data SQLStorageSettings Settings Response - SQL Server Data Storage Settings.
- sql
Log SQLStorageSettings Settings Response - SQL Server Log Storage Settings.
- sql
System booleanDb On Data Disk - SQL Server SystemDb Storage on DataPool if true.
- sql
Temp SQLTempDb Settings Db Settings Response - SQL Server TempDb Storage Settings.
- storage
Workload stringType - Storage workload type.
- disk_
configuration_ strtype - Disk configuration to apply to SQL Server.
- sql_
data_ SQLStoragesettings Settings Response - SQL Server Data Storage Settings.
- sql_
log_ SQLStoragesettings Settings Response - SQL Server Log Storage Settings.
- sql_
system_ booldb_ on_ data_ disk - SQL Server SystemDb Storage on DataPool if true.
- sql_
temp_ SQLTempdb_ settings Db Settings Response - SQL Server TempDb Storage Settings.
- storage_
workload_ strtype - Storage workload type.
- disk
Configuration StringType - Disk configuration to apply to SQL Server.
- sql
Data Property MapSettings - SQL Server Data Storage Settings.
- sql
Log Property MapSettings - SQL Server Log Storage Settings.
- sql
System BooleanDb On Data Disk - SQL Server SystemDb Storage on DataPool if true.
- sql
Temp Property MapDb Settings - SQL Server TempDb Storage Settings.
- storage
Workload StringType - Storage workload type.
StorageWorkloadType, StorageWorkloadTypeArgs
- GENERAL
- GENERAL
- OLTP
- OLTP
- DW
- DW
- Storage
Workload Type GENERAL - GENERAL
- Storage
Workload Type OLTP - OLTP
- Storage
Workload Type DW - 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
- Created
At string - The timestamp of resource creation (UTC).
- Created
By string - The identity that created the resource.
- Created
By stringType - The type of identity that created the resource.
- Last
Modified stringAt - The timestamp of resource last modification (UTC)
- Last
Modified stringBy - The identity that last modified the resource.
- Last
Modified stringBy Type - The type of identity that last modified the resource.
- Created
At string - The timestamp of resource creation (UTC).
- Created
By string - The identity that created the resource.
- Created
By stringType - The type of identity that created the resource.
- Last
Modified stringAt - The timestamp of resource last modification (UTC)
- Last
Modified stringBy - The identity that last modified the resource.
- Last
Modified stringBy Type - The type of identity that last modified the resource.
- created
At String - The timestamp of resource creation (UTC).
- created
By String - The identity that created the resource.
- created
By StringType - The type of identity that created the resource.
- last
Modified StringAt - The timestamp of resource last modification (UTC)
- last
Modified StringBy - The identity that last modified the resource.
- last
Modified StringBy Type - The type of identity that last modified the resource.
- created
At string - The timestamp of resource creation (UTC).
- created
By string - The identity that created the resource.
- created
By stringType - The type of identity that created the resource.
- last
Modified stringAt - The timestamp of resource last modification (UTC)
- last
Modified stringBy - The identity that last modified the resource.
- last
Modified stringBy Type - 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_ strtype - The type of identity that created the resource.
- last_
modified_ strat - The timestamp of resource last modification (UTC)
- last_
modified_ strby - The identity that last modified the resource.
- last_
modified_ strby_ type - The type of identity that last modified the resource.
- created
At String - The timestamp of resource creation (UTC).
- created
By String - The identity that created the resource.
- created
By StringType - The type of identity that created the resource.
- last
Modified StringAt - The timestamp of resource last modification (UTC)
- last
Modified StringBy - The identity that last modified the resource.
- last
Modified StringBy Type - The type of identity that last modified the resource.
WsfcDomainCredentials, WsfcDomainCredentialsArgs
- Cluster
Bootstrap stringAccount Password - Cluster bootstrap account password.
- Cluster
Operator stringAccount Password - Cluster operator account password.
- Sql
Service stringAccount Password - SQL service account password.
- Cluster
Bootstrap stringAccount Password - Cluster bootstrap account password.
- Cluster
Operator stringAccount Password - Cluster operator account password.
- Sql
Service stringAccount Password - SQL service account password.
- cluster
Bootstrap StringAccount Password - Cluster bootstrap account password.
- cluster
Operator StringAccount Password - Cluster operator account password.
- sql
Service StringAccount Password - SQL service account password.
- cluster
Bootstrap stringAccount Password - Cluster bootstrap account password.
- cluster
Operator stringAccount Password - Cluster operator account password.
- sql
Service stringAccount Password - SQL service account password.
- cluster_
bootstrap_ straccount_ password - Cluster bootstrap account password.
- cluster_
operator_ straccount_ password - Cluster operator account password.
- sql_
service_ straccount_ password - SQL service account password.
- cluster
Bootstrap StringAccount Password - Cluster bootstrap account password.
- cluster
Operator StringAccount Password - Cluster operator account password.
- sql
Service StringAccount Password - SQL service account password.
WsfcDomainCredentialsResponse, WsfcDomainCredentialsResponseArgs
- Cluster
Bootstrap stringAccount Password - Cluster bootstrap account password.
- Cluster
Operator stringAccount Password - Cluster operator account password.
- Sql
Service stringAccount Password - SQL service account password.
- Cluster
Bootstrap stringAccount Password - Cluster bootstrap account password.
- Cluster
Operator stringAccount Password - Cluster operator account password.
- Sql
Service stringAccount Password - SQL service account password.
- cluster
Bootstrap StringAccount Password - Cluster bootstrap account password.
- cluster
Operator StringAccount Password - Cluster operator account password.
- sql
Service StringAccount Password - SQL service account password.
- cluster
Bootstrap stringAccount Password - Cluster bootstrap account password.
- cluster
Operator stringAccount Password - Cluster operator account password.
- sql
Service stringAccount Password - SQL service account password.
- cluster_
bootstrap_ straccount_ password - Cluster bootstrap account password.
- cluster_
operator_ straccount_ password - Cluster operator account password.
- sql_
service_ straccount_ password - SQL service account password.
- cluster
Bootstrap StringAccount Password - Cluster bootstrap account password.
- cluster
Operator StringAccount Password - Cluster operator account password.
- sql
Service StringAccount Password - 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}
To learn more about importing existing cloud resources, see Importing resources.
Package Details
- Repository
- Azure Native pulumi/pulumi-azure-native
- License
- Apache-2.0
This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.
Azure Native v2.64.2 published on Tuesday, Oct 1, 2024 by Pulumi