New-AzSqlVM

Reference

Module:: Az.SqlVirtualMachine

Creates or updates a SQL virtual machine.

Syntax

New-AzSqlVM
   -Name <String>
   -ResourceGroupName <String>
   [-SubscriptionId <String>]
   -Location <String>
   [-AdditionalFeatureServerConfigurationIsRServicesEnabled]
   [-AssessmentSettingEnable]
   [-AssessmentSettingRunImmediately]
   [-AutoBackupSettingBackupScheduleType <BackupScheduleType>]
   [-AutoBackupSettingBackupSystemDb]
   [-AutoBackupSettingDaysOfWeek <AutoBackupDaysOfWeek[]>]
   [-AutoBackupSettingEnable]
   [-AutoBackupSettingEnableEncryption]
   [-AutoBackupSettingFullBackupFrequency <FullBackupFrequencyType>]
   [-AutoBackupSettingFullBackupStartTime <Int32>]
   [-AutoBackupSettingFullBackupWindowHour <Int32>]
   [-AutoBackupSettingLogBackupFrequency <Int32>]
   [-AutoBackupSettingPassword <SecureString>]
   [-AutoBackupSettingRetentionPeriod <Int32>]
   [-AutoBackupSettingStorageAccessKey <String>]
   [-AutoBackupSettingStorageAccountUrl <String>]
   [-AutoBackupSettingStorageContainerName <String>]
   [-AutoPatchingSettingDayOfWeek <DayOfWeek>]
   [-AutoPatchingSettingEnable]
   [-AutoPatchingSettingMaintenanceWindowDuration <Int32>]
   [-AutoPatchingSettingMaintenanceWindowStartingHour <Int32>]
   [-AzureAdAuthenticationSettingClientId <String>]
   [-EnableAutomaticUpgrade]
   [-IdentityType <IdentityType>]
   [-KeyVaultCredentialSettingAzureKeyVaultUrl <String>]
   [-KeyVaultCredentialSettingCredentialName <String>]
   [-KeyVaultCredentialSettingEnable]
   [-KeyVaultCredentialSettingServicePrincipalName <String>]
   [-KeyVaultCredentialSettingServicePrincipalSecret <String>]
   [-LeastPrivilegeMode <LeastPrivilegeMode>]
   [-LicenseType <SqlServerLicenseType>]
   [-Offer <String>]
   [-ScheduleDayOfWeek <AssessmentDayOfWeek>]
   [-ScheduleEnable]
   [-ScheduleMonthlyOccurrence <Int32>]
   [-ScheduleStartTime <String>]
   [-ScheduleWeeklyInterval <Int32>]
   [-Sku <SqlImageSku>]
   [-SqlConnectivityUpdateSettingConnectivityType <ConnectivityType>]
   [-SqlConnectivityUpdateSettingPort <Int32>]
   [-SqlConnectivityUpdateSettingSqlAuthUpdatePassword <SecureString>]
   [-SqlConnectivityUpdateSettingSqlAuthUpdateUserName <String>]
   [-SqlDataSettingDefaultFilePath <String>]
   [-SqlDataSettingLun <Int32[]>]
   [-SqlInstanceSettingCollation <String>]
   [-SqlInstanceSettingIsIfiEnabled]
   [-SqlInstanceSettingIsLpimEnabled]
   [-SqlInstanceSettingIsOptimizeForAdHocWorkloadsEnabled]
   [-SqlInstanceSettingMaxDop <Int32>]
   [-SqlInstanceSettingMaxServerMemoryMb <Int32>]
   [-SqlInstanceSettingMinServerMemoryMb <Int32>]
   [-SqlLogSettingDefaultFilePath <String>]
   [-SqlLogSettingLun <Int32[]>]
   [-SqlManagementType <SqlManagementMode>]
   [-SqlStorageUpdateSettingDiskConfigurationType <DiskConfigurationType>]
   [-SqlStorageUpdateSettingDiskCount <Int32>]
   [-SqlStorageUpdateSettingStartingDeviceId <Int32>]
   [-SqlTempDbSettingDataFileCount <Int32>]
   [-SqlTempDbSettingDataFileSize <Int32>]
   [-SqlTempDbSettingDataGrowth <Int32>]
   [-SqlTempDbSettingDefaultFilePath <String>]
   [-SqlTempDbSettingLogFileSize <Int32>]
   [-SqlTempDbSettingLogGrowth <Int32>]
   [-SqlTempDbSettingLun <Int32[]>]
   [-SqlTempDbSettingPersistFolder]
   [-SqlTempDbSettingPersistFolderPath <String>]
   [-SqlVirtualMachineGroupResourceId <String>]
   [-SqlWorkloadTypeUpdateSettingSqlWorkloadType <SqlWorkloadType>]
   [-StorageConfigurationSettingDiskConfigurationType <DiskConfigurationType>]
   [-StorageConfigurationSettingSqlSystemDbOnDataDisk]
   [-StorageConfigurationSettingStorageWorkloadType <StorageWorkloadType>]
   [-Tag <Hashtable>]
   [-WsfcDomainCredentialsClusterBootstrapAccountPassword <SecureString>]
   [-WsfcDomainCredentialsClusterOperatorAccountPassword <SecureString>]
   [-WsfcDomainCredentialsSqlServiceAccountPassword <SecureString>]
   [-WsfcStaticIP <String>]
   [-DefaultProfile <PSObject>]
   [-AsJob]
   [-NoWait]
   [-WhatIf]
   [-Confirm]
   [<CommonParameters>]

Description

Creates or updates a SQL virtual machine.

If you are updating an existing SQL virtual machine and a parameter such as -Tag is omitted, then the previously defined values may be removed. For this reason, it is recommended to use Update-AzSqlVM to prevent overwriting of unintended parameters.

Examples

Example 1

New-AzSqlVM -ResourceGroupName 'ResourceGroup01' -Name 'sqlvm1' -Location 'eastus'

Location	Name		ResourceGroupName
--------	----		-----------------
eastus		sqlvm1		ResourceGroup01

Create a SQL virtual machine with default settings.

Example 2

New-AzSqlVM -ResourceGroupName 'ResourceGroup01' -Name 'sqlvm1' -Location 'eastus' -Sku 'Developer' -LicenseType 'PAYG'

Location	Name		ResourceGroupName
--------	----		-----------------
eastus		sqlvm1		ResourceGroup01

Create a SQL virtual machine with specific sku and license type.

Example 3

New-AzSqlVM -ResourceGroupName 'ResourceGroup01' -Name 'sqlvm1' -Location 'eastus' -LicenseType 'AHUB'

Location	Name		ResourceGroupName
--------	----		-----------------
eastus		sqlvm1		ResourceGroup01

Create a SQL virtual machine with AHUB billing tag.

Example 4

New-AzSqlVM -ResourceGroupName 'ResourceGroup01' -Name 'sqlvm1' -Location 'eastus' -LicenseType 'DR'

Location	Name		ResourceGroupName
--------	----		-----------------
eastus		sqlvm1		ResourceGroup01

Create a SQL virtual machine with DR billing tag.

Example 5

New-AzSqlVM -ResourceGroupName 'ResourceGroup01' -Name 'sqlvm1' -Location 'eastus' -AutoBackupSettingEnable `
-AutoBackupSettingBackupScheduleType manual -AutoBackupSettingFullBackupFrequency Weekly -AutoBackupSettingFullBackupStartTime 5 `
-AutoBackupSettingFullBackupWindowHour 2 -AutoBackupSettingStorageAccessKey 'keyvalue' -AutoBackupSettingStorageAccountUrl `
'https://storagename.blob.core.windows.net/' -AutoBackupSettingRetentionPeriod 10 -AutoBackupSettingLogBackupFrequency 60 `
-AutoBackupSettingStorageContainerName 'storagecontainername'

Location	Name		ResourceGroupName
--------	----		-----------------
eastus		sqlvm1		ResourceGroup01

Create a SQL virtual machine and configure auto backup settings.

Example 6

New-AzSqlVM -ResourceGroupName 'ResourceGroup01' -Name 'sqlvm1' -Location 'eastus' -AutoPatchingSettingDayOfWeek Thursday `
-AutoPatchingSettingMaintenanceWindowDuration 120 -AutoPatchingSettingMaintenanceWindowStartingHour 3 -AutoPatchingSettingEnable

Location	Name		ResourceGroupName
--------	----		-----------------
eastus		sqlvm1		ResourceGroup01

Create a SQL virtual machine and configure auto patching settings.

Example 7

New-AzSqlVM -ResourceGroupName 'ResourceGroup01' -Name 'sqlvm1' -Location 'eastus' -AssessmentSettingEnable

Location	Name		ResourceGroupName
--------	----		-----------------
eastus		sqlvm1		ResourceGroup01

Create a SQL virtual machine and configure assessment settings.

Example 8

New-AzSqlVM -ResourceGroupName 'ResourceGroup01' -Name 'sqlvm1' -Location 'eastus' -AsJob

Location	Name		ResourceGroupName
--------	----		-----------------
eastus		sqlvm1		ResourceGroup01

Create a SQL virtual machine as a background job.

Parameters

-AdditionalFeatureServerConfigurationIsRServicesEnabled

Enable or disable R services (SQL 2016 onwards).

Type:	SwitchParameter
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-AsJob

Run the command as a job

Type:	SwitchParameter
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-AssessmentSettingEnable

Enable or disable SQL best practices Assessment feature on SQL virtual machine.

Type:	SwitchParameter
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-AssessmentSettingRunImmediately

Run SQL best practices Assessment immediately on SQL virtual machine.

Type:	SwitchParameter
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-AutoBackupSettingBackupScheduleType

Backup schedule type.

Type:	BackupScheduleType
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-AutoBackupSettingBackupSystemDb

Include or exclude system databases from auto backup.

Type:	SwitchParameter
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-AutoBackupSettingDaysOfWeek

Days of the week for the backups when FullBackupFrequency is set to Weekly.

Type:	AutoBackupDaysOfWeek[]
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-AutoBackupSettingEnable

Enable or disable autobackup on SQL virtual machine.

Type:	SwitchParameter
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-AutoBackupSettingEnableEncryption

Enable or disable encryption for backup on SQL virtual machine.

Type:	SwitchParameter
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-AutoBackupSettingFullBackupFrequency

Frequency of full backups. In both cases, full backups begin during the next scheduled time window.

Type:	FullBackupFrequencyType
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-AutoBackupSettingFullBackupStartTime

Start time of a given day during which full backups can take place. 0-23 hours.

Type:	Int32
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-AutoBackupSettingFullBackupWindowHour

Duration of the time window of a given day during which full backups can take place. 1-23 hours.

Type:	Int32
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-AutoBackupSettingLogBackupFrequency

Frequency of log backups. 5-60 minutes.

Type:	Int32
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-AutoBackupSettingPassword

Password for encryption on backup.

Type:	SecureString
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-AutoBackupSettingRetentionPeriod

Retention period of backup: 1-90 days.

Type:	Int32
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-AutoBackupSettingStorageAccessKey

Storage account key where backup will be taken to.

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-AutoBackupSettingStorageAccountUrl

Storage account url where backup will be taken to.

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-AutoBackupSettingStorageContainerName

Storage container name where backup will be taken to.

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-AutoPatchingSettingDayOfWeek

Day of week to apply the patch on.

Type:	DayOfWeek
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-AutoPatchingSettingEnable

Enable or disable autopatching on SQL virtual machine.

Type:	SwitchParameter
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-AutoPatchingSettingMaintenanceWindowDuration

Duration of patching.

Type:	Int32
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-AutoPatchingSettingMaintenanceWindowStartingHour

Hour of the day when patching is initiated. Local VM time.

Type:	Int32
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-AzureAdAuthenticationSettingClientId

The client Id of the Managed Identity to query Microsoft Graph API. An empty string must be used for the system assigned Managed Identity

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Confirm

Prompts you for confirmation before running the cmdlet.

Type:	SwitchParameter
Aliases:	cf
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-DefaultProfile

The credentials, account, tenant, and subscription used for communication with Azure.

Type:	PSObject
Aliases:	AzureRMContext, AzureCredential
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-EnableAutomaticUpgrade

Enable automatic upgrade of Sql IaaS extension Agent.

Type:	SwitchParameter
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-IdentityType

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

Type:	IdentityType
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-KeyVaultCredentialSettingAzureKeyVaultUrl

Azure Key Vault url.

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-KeyVaultCredentialSettingCredentialName

Credential name.

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-KeyVaultCredentialSettingEnable

Enable or disable key vault credential setting.

Type:	SwitchParameter
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-KeyVaultCredentialSettingServicePrincipalName

Service principal name to access key vault.

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-KeyVaultCredentialSettingServicePrincipalSecret

Service principal name secret to access key vault.

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-LeastPrivilegeMode

SQL IaaS Agent least privilege mode.

Type:	LeastPrivilegeMode
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-LicenseType

SQL Server license type.

Type:	SqlServerLicenseType
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Location

Resource location.

Type:	String
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-Name

Name of the SQL virtual machine.

Type:	String
Aliases:	SqlVirtualMachineName, SqlVMName
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-NoWait

Run the command asynchronously

Type:	SwitchParameter
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Offer

SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-ResourceGroupName

Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

Type:	String
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-ScheduleDayOfWeek

Day of the week to run assessment.

Type:	AssessmentDayOfWeek
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-ScheduleEnable

Enable or disable assessment schedule on SQL virtual machine.

Type:	SwitchParameter
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-ScheduleMonthlyOccurrence

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

Type:	Int32
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-ScheduleStartTime

Time of the day in HH:mm format. Eg. 17:30

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-ScheduleWeeklyInterval

Number of weeks to schedule between 2 assessment runs. Takes value from 1-6

Type:	Int32
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Sku

SQL Server edition type.

Type:	SqlImageSku
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlConnectivityUpdateSettingConnectivityType

SQL Server connectivity option.

Type:	ConnectivityType
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlConnectivityUpdateSettingPort

SQL Server port.

Type:	Int32
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlConnectivityUpdateSettingSqlAuthUpdatePassword

SQL Server sysadmin login password.

Type:	SecureString
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlConnectivityUpdateSettingSqlAuthUpdateUserName

SQL Server sysadmin login to create.

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlDataSettingDefaultFilePath

SQL Server default file path

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlDataSettingLun

Logical Unit Numbers for the disks.

Type:	Int32[]
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlInstanceSettingCollation

SQL Server Collation.

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlInstanceSettingIsIfiEnabled

SQL Server IFI.

Type:	SwitchParameter
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlInstanceSettingIsLpimEnabled

SQL Server LPIM.

Type:	SwitchParameter
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlInstanceSettingIsOptimizeForAdHocWorkloadsEnabled

SQL Server Optimize for Adhoc workloads.

Type:	SwitchParameter
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlInstanceSettingMaxDop

SQL Server MAXDOP.

Type:	Int32
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlInstanceSettingMaxServerMemoryMb

SQL Server maximum memory.

Type:	Int32
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlInstanceSettingMinServerMemoryMb

SQL Server minimum memory.

Type:	Int32
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlLogSettingDefaultFilePath

SQL Server default file path

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlLogSettingLun

Logical Unit Numbers for the disks.

Type:	Int32[]
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlManagementType

SQL Server Management type.

Type:	SqlManagementMode
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlStorageUpdateSettingDiskConfigurationType

Disk configuration to apply to SQL Server.

Type:	DiskConfigurationType
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlStorageUpdateSettingDiskCount

Virtual machine disk count.

Type:	Int32
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlStorageUpdateSettingStartingDeviceId

Device id of the first disk to be updated.

Type:	Int32
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlTempDbSettingDataFileCount

SQL Server tempdb data file count

Type:	Int32
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlTempDbSettingDataFileSize

SQL Server tempdb data file size

Type:	Int32
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlTempDbSettingDataGrowth

SQL Server tempdb data file autoGrowth size

Type:	Int32
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlTempDbSettingDefaultFilePath

SQL Server default file path

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlTempDbSettingLogFileSize

SQL Server tempdb log file size

Type:	Int32
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlTempDbSettingLogGrowth

SQL Server tempdb log file autoGrowth size

Type:	Int32
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlTempDbSettingLun

Logical Unit Numbers for the disks.

Type:	Int32[]
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlTempDbSettingPersistFolder

SQL Server tempdb persist folder choice

Type:	SwitchParameter
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlTempDbSettingPersistFolderPath

SQL Server tempdb persist folder location

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlVirtualMachineGroupResourceId

ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SqlWorkloadTypeUpdateSettingSqlWorkloadType

SQL Server workload type.

Type:	SqlWorkloadType
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-StorageConfigurationSettingDiskConfigurationType

Disk configuration to apply to SQL Server.

Type:	DiskConfigurationType
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-StorageConfigurationSettingSqlSystemDbOnDataDisk

SQL Server SystemDb Storage on DataPool if true.

Type:	SwitchParameter
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-StorageConfigurationSettingStorageWorkloadType

Storage workload type.

Type:	StorageWorkloadType
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SubscriptionId

Subscription ID that identifies an Azure subscription.

Type:	String
Position:	Named
Default value:	(Get-AzContext).Subscription.Id
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Tag

Resource tags.

Type:	Hashtable
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-WhatIf

Shows what would happen if the cmdlet runs. The cmdlet is not run.

Type:	SwitchParameter
Aliases:	wi
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-WsfcDomainCredentialsClusterBootstrapAccountPassword

Cluster bootstrap account password.

Type:	SecureString
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-WsfcDomainCredentialsClusterOperatorAccountPassword

Cluster operator account password.

Type:	SecureString
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-WsfcDomainCredentialsSqlServiceAccountPassword

SQL service account password.

Type:	SecureString
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-WsfcStaticIP

Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

Outputs

ISqlVirtualMachine

次の方法で共有

New-AzSqlVM

Syntax

Description

Examples

Example 1

Example 2

Example 3

Example 4

Example 5

Example 6

Example 7

Example 8

Parameters

-AdditionalFeatureServerConfigurationIsRServicesEnabled

-AsJob

-AssessmentSettingEnable

-AssessmentSettingRunImmediately

-AutoBackupSettingBackupScheduleType

-AutoBackupSettingBackupSystemDb

-AutoBackupSettingDaysOfWeek

-AutoBackupSettingEnable

-AutoBackupSettingEnableEncryption

-AutoBackupSettingFullBackupFrequency

-AutoBackupSettingFullBackupStartTime

-AutoBackupSettingFullBackupWindowHour

-AutoBackupSettingLogBackupFrequency

-AutoBackupSettingPassword

-AutoBackupSettingRetentionPeriod

-AutoBackupSettingStorageAccessKey

-AutoBackupSettingStorageAccountUrl

-AutoBackupSettingStorageContainerName

-AutoPatchingSettingDayOfWeek

-AutoPatchingSettingEnable

-AutoPatchingSettingMaintenanceWindowDuration

-AutoPatchingSettingMaintenanceWindowStartingHour

-AzureAdAuthenticationSettingClientId

-Confirm

-DefaultProfile

-EnableAutomaticUpgrade

-IdentityType

-KeyVaultCredentialSettingAzureKeyVaultUrl

-KeyVaultCredentialSettingCredentialName

-KeyVaultCredentialSettingEnable

-KeyVaultCredentialSettingServicePrincipalName

-KeyVaultCredentialSettingServicePrincipalSecret

-LeastPrivilegeMode

-LicenseType

-Location

-Name

-NoWait

-Offer

-ResourceGroupName

-ScheduleDayOfWeek

-ScheduleEnable

-ScheduleMonthlyOccurrence

-ScheduleStartTime

-ScheduleWeeklyInterval

-Sku

-SqlConnectivityUpdateSettingConnectivityType

-SqlConnectivityUpdateSettingPort

-SqlConnectivityUpdateSettingSqlAuthUpdatePassword

-SqlConnectivityUpdateSettingSqlAuthUpdateUserName

-SqlDataSettingDefaultFilePath

-SqlDataSettingLun

-SqlInstanceSettingCollation

-SqlInstanceSettingIsIfiEnabled

-SqlInstanceSettingIsLpimEnabled

-SqlInstanceSettingIsOptimizeForAdHocWorkloadsEnabled

-SqlInstanceSettingMaxDop

-SqlInstanceSettingMaxServerMemoryMb

-SqlInstanceSettingMinServerMemoryMb

-SqlLogSettingDefaultFilePath

-SqlLogSettingLun

-SqlManagementType

-SqlStorageUpdateSettingDiskConfigurationType

-SqlStorageUpdateSettingDiskCount

-SqlStorageUpdateSettingStartingDeviceId

-SqlTempDbSettingDataFileCount

-SqlTempDbSettingDataFileSize