New-AzSqlVM
建立或更新 SQL 虛擬機。
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
建立或更新 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 之受控識別的用戶端標識碼。 空字串必須用於系統指派的受控識別
| 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』，以自動建立並指派資源的 Microsoft Entra 主體。
| 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 Resource Manager 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 系統管理員登入密碼。
| Type: | SecureString |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SqlConnectivityUpdateSettingSqlAuthUpdateUserName
要建立的 SQL Server 系統管理員登入。
| 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 優化 Adhoc 工作負載。
| 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
要更新之第一個磁碟的裝置標識碼。
| 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 儲存資料夾選擇
| 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 虛擬機器群組的 ARM 資源識別碼，此 SQL 虛擬機是或將會是其中的一部分。
| 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 訂用帳戶的訂用帳戶標識碼。
| 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 |
輸出
備註
別名