你当前正在访问 Microsoft Azure Global Edition 技术文档网站。如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站，请访问 https://docs.azure.cn。

New-AzSqlVM

参考

模块:: Az.SqlVirtualMachine

创建或更新 SQL 虚拟机。

语法

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 来防止覆盖意外参数。

示例

示例 1

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

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

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

示例 2

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

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

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

示例 3

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

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

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

示例 4

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

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

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

示例 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

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

示例 6

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

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

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

示例 7

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

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

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

示例 8

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

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

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

参数

-AdditionalFeatureServerConfigurationIsRServicesEnabled

启用或禁用 R 服务（SQL 2016 及更高版本）。

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

-AsJob

以作业身份运行命令

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

-AssessmentSettingEnable

启用或禁用 SQL 虚拟机上的 SQL 最佳做法评估功能。

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

-AssessmentSettingRunImmediately

立即在 SQL 虚拟机上运行 SQL 最佳做法评估。

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

-AutoBackupSettingBackupScheduleType

备份计划类型。

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

-AutoBackupSettingBackupSystemDb

包括或排除自动备份中的系统数据库。

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

-AutoBackupSettingDaysOfWeek

当 FullBackupFrequency 设置为“每周”时，备份的一周中的天数。

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

-AutoBackupSettingEnable

在 SQL 虚拟机上启用或禁用自动回退。

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

-AutoBackupSettingEnableEncryption

启用或禁用 SQL 虚拟机上备份的加密。

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

-AutoBackupSettingFullBackupFrequency

完整备份的频率。上述两种情况下，均在下一个计划的时间段内开始完整备份。

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

-AutoBackupSettingFullBackupStartTime

在给定的日期可以开始执行完整备份的时间。 0-23 小时。

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

-AutoBackupSettingFullBackupWindowHour

在给定的日期可以执行完整备份的时段持续时间。 1-23 小时。

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

-AutoBackupSettingLogBackupFrequency

日志备份的频率。 5-60 分钟。

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

-AutoBackupSettingPassword

备份时加密的密码。

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

-AutoBackupSettingRetentionPeriod

备份的保留期：1-90 天。

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

-AutoBackupSettingStorageAccessKey

存储将备份到的帐户密钥。

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

-AutoBackupSettingStorageAccountUrl

存储将备份到的帐户 URL。

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

-AutoBackupSettingStorageContainerName

存储将备份到的容器名称。

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

-AutoPatchingSettingDayOfWeek

应用修补程序的一周中的一天。

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

-AutoPatchingSettingEnable

在 SQL 虚拟机上启用或禁用自动修补。

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

-AutoPatchingSettingMaintenanceWindowDuration

修补的持续时间。

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

-AutoPatchingSettingMaintenanceWindowStartingHour

开始修补的一天中的一小时。本地 VM 时间。

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

-AzureAdAuthenticationSettingClientId

用于查询 Microsoft Graph API 的托管标识的客户端 ID。空字符串必须用于系统分配的托管标识

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

-Confirm

提示你在运行 cmdlet 之前进行确认。

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

-DefaultProfile

用于与 Azure 通信的凭据、帐户、租户和订阅。

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

-EnableAutomaticUpgrade

启用 Sql IaaS 扩展代理的自动升级。

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

-IdentityType

标识类型。将此设置为“SystemAssigned”，以便自动为资源创建和分配 Azure Active Directory 主体。

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

-KeyVaultCredentialSettingAzureKeyVaultUrl

Azure 密钥库 URL。

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

-KeyVaultCredentialSettingCredentialName

凭据名称。

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

-KeyVaultCredentialSettingEnable

启用或禁用密钥保管库凭据设置。

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

-KeyVaultCredentialSettingServicePrincipalName

用于访问密钥保管库的服务主体名称。

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

-KeyVaultCredentialSettingServicePrincipalSecret

用于访问密钥保管库的服务主体名称机密。

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

-LeastPrivilegeMode

SQL IaaS 代理最低特权模式。

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

-LicenseType

SQL Server 许可证类型。

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

-Location

资源位置。

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

-Name

SQL 虚拟机的名称。

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

-NoWait

异步运行命令

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

-Offer

SQL 映像产品/服务。示例包括 SQL2016-WS2016、SQL2017-WS2016。

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

-ResourceGroupName

包含资源的资源组的名称。可以从 Azure 资源管理器 API 或门户获取此值。

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

-ScheduleDayOfWeek

运行评估的一周中的一天。

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

-ScheduleEnable

在 SQL 虚拟机上启用或禁用评估计划。

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

-ScheduleMonthlyOccurrence

在一个月内发生 DayOfWeek 日期以安排评估。采用值：1,2,3,4 和 -1。将 -1 用于当月的最后一天OfWeek 日

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

-ScheduleStartTime

以 HH：mm 格式表示的一天时间。例如17:30

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

-ScheduleWeeklyInterval

计划 2 个评估运行之间的周数。从 1-6 获取值

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

-Sku

SQL Server 版本类型。

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

-SqlConnectivityUpdateSettingConnectivityType

SQL Server 连接选项。

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

-SqlConnectivityUpdateSettingPort

SQL Server 端口。

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

-SqlConnectivityUpdateSettingSqlAuthUpdatePassword

SQL Server sysadmin 登录密码。

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

-SqlConnectivityUpdateSettingSqlAuthUpdateUserName

要创建的 SQL Server sysadmin 登录名。

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

-SqlDataSettingDefaultFilePath

SQL Server 默认文件路径

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

-SqlDataSettingLun

磁盘的逻辑单元号。

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

-SqlInstanceSettingCollation

SQL Server 排序规则。

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 最大内存。

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

-SqlInstanceSettingMinServerMemoryMb

SQL Server 最小内存。

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

-SqlLogSettingDefaultFilePath

SQL Server 默认文件路径

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

-SqlLogSettingLun

磁盘的逻辑单元号。

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

-SqlManagementType

SQL Server 管理类型。

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

-SqlStorageUpdateSettingDiskConfigurationType

要应用于 SQL Server 的磁盘配置。

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

-SqlStorageUpdateSettingDiskCount

虚拟机磁盘计数。

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

-SqlStorageUpdateSettingStartingDeviceId

要更新的第一个磁盘的设备 ID。

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

-SqlTempDbSettingDataFileCount

SQL Server tempdb 数据文件计数

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

-SqlTempDbSettingDataFileSize

SQL Server tempdb 数据文件大小

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

-SqlTempDbSettingDataGrowth

SQL Server tempdb 数据文件自动增长大小

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

-SqlTempDbSettingDefaultFilePath

SQL Server 默认文件路径

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

-SqlTempDbSettingLogFileSize

SQL Server tempdb 日志文件大小

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

-SqlTempDbSettingLogGrowth

SQL Server tempdb 日志文件自动增长大小

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

-SqlTempDbSettingLun

磁盘的逻辑单元号。

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

-SqlTempDbSettingPersistFolder

SQL Server tempdb persist 文件夹选项

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

-SqlTempDbSettingPersistFolderPath

SQL Server tempdb 保留文件夹位置

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

-SqlVirtualMachineGroupResourceId

此 SQL 虚拟机所属的 SQL 虚拟机组的 ARM 资源 ID 或将成为其中的一部分。

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

-SqlWorkloadTypeUpdateSettingSqlWorkloadType

SQL Server 工作负荷类型。

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

-StorageConfigurationSettingDiskConfigurationType

要应用于 SQL Server 的磁盘配置。

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

-StorageConfigurationSettingSqlSystemDbOnDataDisk

如果为 true，则 DataPool 上的 SQL Server SystemDb 存储。

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

-StorageConfigurationSettingStorageWorkloadType

存储工作负荷类型。

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

-SubscriptionId

标识 Azure 订阅的订阅 ID。

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

-Tag

资源标记。

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

-WhatIf

显示运行该 cmdlet 时会发生什么情况。 cmdlet 未运行。

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

-WsfcDomainCredentialsClusterBootstrapAccountPassword

群集启动帐户密码。

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

-WsfcDomainCredentialsClusterOperatorAccountPassword

群集操作员帐户密码。

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

-WsfcDomainCredentialsSqlServiceAccountPassword

SQL 服务帐户密码。

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

-WsfcStaticIP

用于为 SQL 可用性组设置 Windows Server 故障转移群集的域凭据。

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

输出

ISqlVirtualMachine

通过

New-AzSqlVM

语法

说明

示例

示例 1

示例 2

示例 3

示例 4

示例 5

示例 6

示例 7

示例 8

参数

-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