New-AzSqlVM
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 ResourceGroup01Create 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 ResourceGroup01Create 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 ResourceGroup01Create 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 ResourceGroup01Create 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 ResourceGroup01Create 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 ResourceGroup01Create 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 ResourceGroup01Create a SQL virtual machine and configure assessment settings.
Example 8
New-AzSqlVM -ResourceGroupName 'ResourceGroup01' -Name 'sqlvm1' -Location 'eastus' -AsJob
Location Name ResourceGroupName
-------- ---- -----------------
eastus sqlvm1 ResourceGroup01Create 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 a Microsoft Entra 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
Notes
ALIASES
Azure PowerShell
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for