New-AzSqlVM

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>]

创建或更新 SQL 虚拟机。

如果要更新现有 SQL 虚拟机并省略 -Tag 等参数，则可以删除以前定义的值。 因此，建议使用 Update-AzSqlVM 来防止覆盖意外参数。

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

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

使用默认设置创建 SQL 虚拟机。

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

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

创建具有特定 SKU 和许可证类型的 SQL 虚拟机。

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

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

使用 AHUB 计费标记创建 SQL 虚拟机。

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

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

创建具有 DR 计费标记的 SQL 虚拟机。

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

创建 SQL 虚拟机并配置自动备份设置。

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

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

创建 SQL 虚拟机并配置自动修补设置。

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

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

创建 SQL 虚拟机并配置评估设置。

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

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

创建 SQL 虚拟机作为后台作业。

此 cmdlet 支持通用参数：-Debug、-ErrorAction、-ErrorVariable、-InformationAction、-InformationVariable、-OutBuffer、-OutVariable、-PipelineVariable、-ProgressAction、-Verbose、-WarningAction 和 -WarningVariable。 有关详细信息，请参阅 about_CommonParameters。