Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
New-AzSqlVM
- Module:
- Az.SqlVirtualMachine Module
Creates or updates a SQL virtual machine.
Syntax
Default (Default)
New-AzSqlVM
-Name <String>
-ResourceGroupName <String>
[-SubscriptionId <String>]
-Location <String>
[-AdditionalFeatureServerConfigurationIsRServicesEnabled]
[-AssessmentSettingEnable]
[-AssessmentSettingRunImmediately]
[-AutoBackupSettingBackupScheduleType <String>]
[-AutoBackupSettingBackupSystemDb]
[-AutoBackupSettingDaysOfWeek <String[]>]
[-AutoBackupSettingEnable]
[-AutoBackupSettingEnableEncryption]
[-AutoBackupSettingFullBackupFrequency <String>]
[-AutoBackupSettingFullBackupStartTime <Int32>]
[-AutoBackupSettingFullBackupWindowHour <Int32>]
[-AutoBackupSettingLogBackupFrequency <Int32>]
[-AutoBackupSettingPassword <SecureString>]
[-AutoBackupSettingRetentionPeriod <Int32>]
[-AutoBackupSettingStorageAccessKey <String>]
[-AutoBackupSettingStorageAccountUrl <String>]
[-AutoBackupSettingStorageContainerName <String>]
[-AutoPatchingSettingDayOfWeek <String>]
[-AutoPatchingSettingEnable]
[-AutoPatchingSettingMaintenanceWindowDuration <Int32>]
[-AutoPatchingSettingMaintenanceWindowStartingHour <Int32>]
[-AzureAdAuthenticationSettingClientId <String>]
[-EnableAutomaticUpgrade]
[-IdentityType <String>]
[-KeyVaultCredentialSettingAzureKeyVaultUrl <String>]
[-KeyVaultCredentialSettingCredentialName <String>]
[-KeyVaultCredentialSettingEnable]
[-KeyVaultCredentialSettingServicePrincipalName <String>]
[-KeyVaultCredentialSettingServicePrincipalSecret <String>]
[-LeastPrivilegeMode <String>]
[-LicenseType <String>]
[-Offer <String>]
[-ScheduleDayOfWeek <String>]
[-ScheduleEnable]
[-ScheduleMonthlyOccurrence <Int32>]
[-ScheduleStartTime <String>]
[-ScheduleWeeklyInterval <Int32>]
[-Sku <String>]
[-SqlConnectivityUpdateSettingConnectivityType <String>]
[-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 <String>]
[-SqlStorageUpdateSettingDiskConfigurationType <String>]
[-SqlStorageUpdateSettingDiskCount <Int32>]
[-SqlStorageUpdateSettingStartingDeviceId <Int32>]
[-SqlTempDbSettingDataFileCount <Int32>]
[-SqlTempDbSettingDataFileSize <Int32>]
[-SqlTempDbSettingDataGrowth <Int32>]
[-SqlTempDbSettingDefaultFilePath <String>]
[-SqlTempDbSettingLogFileSize <Int32>]
[-SqlTempDbSettingLogGrowth <Int32>]
[-SqlTempDbSettingLun <Int32[]>]
[-SqlTempDbSettingPersistFolder]
[-SqlTempDbSettingPersistFolderPath <String>]
[-SqlVirtualMachineGroupResourceId <String>]
[-SqlWorkloadTypeUpdateSettingSqlWorkloadType <String>]
[-StorageConfigurationSettingDiskConfigurationType <String>]
[-StorageConfigurationSettingSqlSystemDbOnDataDisk]
[-StorageConfigurationSettingStorageWorkloadType <String>]
[-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).
Parameter properties
| Type: | SwitchParameter |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-AsJob
Run the command as a job
Parameter properties
| Type: | SwitchParameter |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-AssessmentSettingEnable
Enable or disable SQL best practices Assessment feature on SQL virtual machine.
Parameter properties
| Type: | SwitchParameter |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-AssessmentSettingRunImmediately
Run SQL best practices Assessment immediately on SQL virtual machine.
Parameter properties
| Type: | SwitchParameter |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-AutoBackupSettingBackupScheduleType
Backup schedule type.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-AutoBackupSettingBackupSystemDb
Include or exclude system databases from auto backup.
Parameter properties
| Type: | SwitchParameter |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-AutoBackupSettingDaysOfWeek
Days of the week for the backups when FullBackupFrequency is set to Weekly.
Parameter properties
| Type: | String[] |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-AutoBackupSettingEnable
Enable or disable autobackup on SQL virtual machine.
Parameter properties
| Type: | SwitchParameter |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-AutoBackupSettingEnableEncryption
Enable or disable encryption for backup on SQL virtual machine.
Parameter properties
| Type: | SwitchParameter |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-AutoBackupSettingFullBackupFrequency
Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-AutoBackupSettingFullBackupStartTime
Start time of a given day during which full backups can take place. 0-23 hours.
Parameter properties
| Type: | Int32 |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-AutoBackupSettingFullBackupWindowHour
Duration of the time window of a given day during which full backups can take place. 1-23 hours.
Parameter properties
| Type: | Int32 |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-AutoBackupSettingLogBackupFrequency
Frequency of log backups. 5-60 minutes.
Parameter properties
| Type: | Int32 |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-AutoBackupSettingPassword
Password for encryption on backup.
Parameter properties
| Type: | SecureString |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-AutoBackupSettingRetentionPeriod
Retention period of backup: 1-90 days.
Parameter properties
| Type: | Int32 |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-AutoBackupSettingStorageAccessKey
Storage account key where backup will be taken to.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-AutoBackupSettingStorageAccountUrl
Storage account url where backup will be taken to.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-AutoBackupSettingStorageContainerName
Storage container name where backup will be taken to.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-AutoPatchingSettingDayOfWeek
Day of week to apply the patch on.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-AutoPatchingSettingEnable
Enable or disable autopatching on SQL virtual machine.
Parameter properties
| Type: | SwitchParameter |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-AutoPatchingSettingMaintenanceWindowDuration
Duration of patching.
Parameter properties
| Type: | Int32 |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-AutoPatchingSettingMaintenanceWindowStartingHour
Hour of the day when patching is initiated. Local VM time.
Parameter properties
| Type: | Int32 |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-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
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-Confirm
Prompts you for confirmation before running the cmdlet.
Parameter properties
| Type: | SwitchParameter |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
| Aliases: | cf |
Parameter sets
-DefaultProfile
The credentials, account, tenant, and subscription used for communication with Azure.
Parameter properties
| Type: | PSObject |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
| Aliases: | AzureRMContext, AzureCredential |
Parameter sets
-EnableAutomaticUpgrade
Enable automatic upgrade of Sql IaaS extension Agent.
Parameter properties
| Type: | SwitchParameter |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-IdentityType
The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-KeyVaultCredentialSettingAzureKeyVaultUrl
Azure Key Vault url.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-KeyVaultCredentialSettingCredentialName
Credential name.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-KeyVaultCredentialSettingEnable
Enable or disable key vault credential setting.
Parameter properties
| Type: | SwitchParameter |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-KeyVaultCredentialSettingServicePrincipalName
Service principal name to access key vault.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-KeyVaultCredentialSettingServicePrincipalSecret
Service principal name secret to access key vault.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-LeastPrivilegeMode
SQL IaaS Agent least privilege mode.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-LicenseType
SQL Server license type.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-Location
Resource location.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-Name
Name of the SQL virtual machine.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
| Aliases: | SqlVirtualMachineName, SqlVMName |
Parameter sets
-NoWait
Run the command asynchronously
Parameter properties
| Type: | SwitchParameter |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-Offer
SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-ResourceGroupName
Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-ScheduleDayOfWeek
Day of the week to run assessment.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-ScheduleEnable
Enable or disable assessment schedule on SQL virtual machine.
Parameter properties
| Type: | SwitchParameter |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-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
Parameter properties
| Type: | Int32 |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-ScheduleStartTime
Time of the day in HH:mm format. Eg. 17:30
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-ScheduleWeeklyInterval
Number of weeks to schedule between 2 assessment runs. Takes value from 1-6
Parameter properties
| Type: | Int32 |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-Sku
SQL Server edition type.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SqlConnectivityUpdateSettingConnectivityType
SQL Server connectivity option.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SqlConnectivityUpdateSettingPort
SQL Server port.
Parameter properties
| Type: | Int32 |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SqlConnectivityUpdateSettingSqlAuthUpdatePassword
SQL Server sysadmin login password.
Parameter properties
| Type: | SecureString |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SqlConnectivityUpdateSettingSqlAuthUpdateUserName
SQL Server sysadmin login to create.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SqlDataSettingDefaultFilePath
SQL Server default file path
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SqlDataSettingLun
Logical Unit Numbers for the disks.
Parameter properties
| Type: | Int32[] |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SqlInstanceSettingCollation
SQL Server Collation.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SqlInstanceSettingIsIfiEnabled
SQL Server IFI.
Parameter properties
| Type: | SwitchParameter |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SqlInstanceSettingIsLpimEnabled
SQL Server LPIM.
Parameter properties
| Type: | SwitchParameter |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SqlInstanceSettingIsOptimizeForAdHocWorkloadsEnabled
SQL Server Optimize for Adhoc workloads.
Parameter properties
| Type: | SwitchParameter |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SqlInstanceSettingMaxDop
SQL Server MAXDOP.
Parameter properties
| Type: | Int32 |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SqlInstanceSettingMaxServerMemoryMb
SQL Server maximum memory.
Parameter properties
| Type: | Int32 |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SqlInstanceSettingMinServerMemoryMb
SQL Server minimum memory.
Parameter properties
| Type: | Int32 |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SqlLogSettingDefaultFilePath
SQL Server default file path
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SqlLogSettingLun
Logical Unit Numbers for the disks.
Parameter properties
| Type: | Int32[] |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SqlManagementType
SQL Server Management type.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SqlStorageUpdateSettingDiskConfigurationType
Disk configuration to apply to SQL Server.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SqlStorageUpdateSettingDiskCount
Virtual machine disk count.
Parameter properties
| Type: | Int32 |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SqlStorageUpdateSettingStartingDeviceId
Device id of the first disk to be updated.
Parameter properties
| Type: | Int32 |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SqlTempDbSettingDataFileCount
SQL Server tempdb data file count
Parameter properties
| Type: | Int32 |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SqlTempDbSettingDataFileSize
SQL Server tempdb data file size
Parameter properties
| Type: | Int32 |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SqlTempDbSettingDataGrowth
SQL Server tempdb data file autoGrowth size
Parameter properties
| Type: | Int32 |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SqlTempDbSettingDefaultFilePath
SQL Server default file path
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SqlTempDbSettingLogFileSize
SQL Server tempdb log file size
Parameter properties
| Type: | Int32 |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SqlTempDbSettingLogGrowth
SQL Server tempdb log file autoGrowth size
Parameter properties
| Type: | Int32 |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SqlTempDbSettingLun
Logical Unit Numbers for the disks.
Parameter properties
| Type: | Int32[] |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SqlTempDbSettingPersistFolder
SQL Server tempdb persist folder choice
Parameter properties
| Type: | SwitchParameter |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SqlTempDbSettingPersistFolderPath
SQL Server tempdb persist folder location
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SqlVirtualMachineGroupResourceId
ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SqlWorkloadTypeUpdateSettingSqlWorkloadType
SQL Server workload type.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-StorageConfigurationSettingDiskConfigurationType
Disk configuration to apply to SQL Server.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-StorageConfigurationSettingSqlSystemDbOnDataDisk
SQL Server SystemDb Storage on DataPool if true.
Parameter properties
| Type: | SwitchParameter |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-StorageConfigurationSettingStorageWorkloadType
Storage workload type.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-SubscriptionId
Subscription ID that identifies an Azure subscription.
Parameter properties
| Type: | String |
| Default value: | (Get-AzContext).Subscription.Id |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-Tag
Resource tags.
Parameter properties
| Type: | Hashtable |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-WhatIf
Shows what would happen if the cmdlet runs. The cmdlet is not run.
Parameter properties
| Type: | SwitchParameter |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
| Aliases: | wi |
Parameter sets
-WsfcDomainCredentialsClusterBootstrapAccountPassword
Cluster bootstrap account password.
Parameter properties
| Type: | SecureString |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-WsfcDomainCredentialsClusterOperatorAccountPassword
Cluster operator account password.
Parameter properties
| Type: | SecureString |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-WsfcDomainCredentialsSqlServiceAccountPassword
SQL service account password.
Parameter properties
| Type: | SecureString |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
-WsfcStaticIP
Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
CommonParameters
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutBuffer, -OutVariable, -PipelineVariable, -ProgressAction, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.
Outputs
Microsoft.Azure.PowerShell.Cmdlets.SqlVirtualMachine.Models.ISqlVirtualMachine
Azure PowerShell
Feedback
Was this page helpful?