New-AzSqlVM

Modul:

Az.SqlVirtualMachine

Membuat atau memperbarui komputer virtual SQL.

Sintaks

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

Deskripsi

Membuat atau memperbarui komputer virtual SQL.

Jika Anda memperbarui komputer virtual SQL yang ada dan parameter seperti -Tag dihilangkan, maka nilai yang ditentukan sebelumnya dapat dihapus. Untuk alasan ini, disarankan untuk menggunakan Update-AzSqlVM untuk mencegah penimpaan parameter yang tidak diinginkan.

Contoh

Contoh 1

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

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

Buat komputer virtual SQL dengan pengaturan default.

Contoh 2

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

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

Buat komputer virtual SQL dengan sku dan jenis lisensi tertentu.

Contoh 3

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

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

Buat komputer virtual SQL dengan tag penagihan AHUB.

Contoh 4

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

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

Buat komputer virtual SQL dengan tag penagihan DR.

Contoh 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

Buat komputer virtual SQL dan konfigurasikan pengaturan pencadangan otomatis.

Contoh 6

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

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

Buat komputer virtual SQL dan konfigurasikan pengaturan patching otomatis.

Contoh 7

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

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

Buat komputer virtual SQL dan konfigurasikan pengaturan penilaian.

Contoh 8

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

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

Buat komputer virtual SQL sebagai pekerjaan latar belakang.

Parameter

-AdditionalFeatureServerConfigurationIsRServicesEnabled

Aktifkan atau nonaktifkan layanan R (SQL 2016 dan seterusnya).

Jenis:	SwitchParameter
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-AsJob

Jalankan perintah sebagai pekerjaan

Jenis:	SwitchParameter
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-AssessmentSettingEnable

Aktifkan atau nonaktifkan fitur Penilaian praktik terbaik SQL pada komputer virtual SQL.

Jenis:	SwitchParameter
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-AssessmentSettingRunImmediately

Jalankan Penilaian praktik terbaik SQL segera pada komputer virtual SQL.

Jenis:	SwitchParameter
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-AutoBackupSettingBackupScheduleType

Jenis jadwal pencadangan.

Jenis:	BackupScheduleType
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-AutoBackupSettingBackupSystemDb

Sertakan atau kecualikan database sistem dari pencadangan otomatis.

Jenis:	SwitchParameter
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-AutoBackupSettingDaysOfWeek

Hari dalam seminggu untuk cadangan ketika FullBackupFrequency diatur ke Mingguan.

Jenis:	AutoBackupDaysOfWeek[]
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-AutoBackupSettingEnable

Aktifkan atau nonaktifkan pencadangan otomatis pada komputer virtual SQL.

Jenis:	SwitchParameter
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-AutoBackupSettingEnableEncryption

Aktifkan atau nonaktifkan enkripsi untuk pencadangan pada komputer virtual SQL.

Jenis:	SwitchParameter
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-AutoBackupSettingFullBackupFrequency

Frekuensi pencadangan penuh. Dalam kedua kasus, pencadangan penuh dimulai selama jendela waktu terjadwal berikutnya.

Jenis:	FullBackupFrequencyType
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-AutoBackupSettingFullBackupStartTime

Waktu mulai hari tertentu kapan pencadangan penuh dapat berlangsung. 0-23 jam.

Jenis:	Int32
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-AutoBackupSettingFullBackupWindowHour

Durasi jendela waktu pada hari tertentu kapan pencadangan penuh dapat dilakukan. 1-23 jam.

Jenis:	Int32
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-AutoBackupSettingLogBackupFrequency

Frekuensi pencadangan log. 5-60 menit.

Jenis:	Int32
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-AutoBackupSettingPassword

Kata sandi untuk enkripsi pada cadangan.

Jenis:	SecureString
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-AutoBackupSettingRetentionPeriod

Periode retensi cadangan: 1-90 hari.

Jenis:	Int32
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-AutoBackupSettingStorageAccessKey

Kunci akun penyimpanan tempat pencadangan akan dibawa.

Jenis:	String
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-AutoBackupSettingStorageAccountUrl

Url akun penyimpanan tempat pencadangan akan diambil.

Jenis:	String
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-AutoBackupSettingStorageContainerName

Nama kontainer penyimpanan tempat cadangan akan diambil.

Jenis:	String
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-AutoPatchingSettingDayOfWeek

Hari dalam seminggu untuk menerapkan patch pada.

Jenis:	DayOfWeek
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-AutoPatchingSettingEnable

Aktifkan atau nonaktifkan pengiriman otomatis pada komputer virtual SQL.

Jenis:	SwitchParameter
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-AutoPatchingSettingMaintenanceWindowDuration

Durasi patching.

Jenis:	Int32
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-AutoPatchingSettingMaintenanceWindowStartingHour

Jam hari ketika patching dimulai. Waktu VM lokal.

Jenis:	Int32
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-AzureAdAuthenticationSettingClientId

Id klien Identitas Terkelola untuk mengkueri Microsoft Graph API. String kosong harus digunakan untuk Identitas Terkelola yang ditetapkan sistem

Jenis:	String
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-Confirm

Meminta Anda mengonfirmasi sebelum menjalankan cmdlet.

Jenis:	SwitchParameter
Alias:	cf
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-DefaultProfile

Kredensial, akun, penyewa, dan langganan yang digunakan untuk komunikasi dengan Azure.

Jenis:	PSObject
Alias:	AzureRMContext, AzureCredential
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-EnableAutomaticUpgrade

Aktifkan peningkatan otomatis Agen ekstensi IaaS Sql.

Jenis:	SwitchParameter
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-IdentityType

Jenis identitas. Atur ini ke 'SystemAssigned' untuk membuat dan menetapkan prinsipal Azure Active Directory secara otomatis untuk sumber daya.

Jenis:	IdentityType
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-KeyVaultCredentialSettingAzureKeyVaultUrl

Url Azure Key Vault.

Jenis:	String
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-KeyVaultCredentialSettingCredentialName

Nama kredensial.

Jenis:	String
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-KeyVaultCredentialSettingEnable

Mengaktifkan atau menonaktifkan pengaturan kredensial brankas kunci.

Jenis:	SwitchParameter
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-KeyVaultCredentialSettingServicePrincipalName

Nama perwakilan layanan untuk mengakses brankas kunci.

Jenis:	String
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-KeyVaultCredentialSettingServicePrincipalSecret

Rahasia nama perwakilan layanan untuk mengakses brankas kunci.

Jenis:	String
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-LeastPrivilegeMode

Mode hak istimewa terkecil Agen IaaS SQL.

Jenis:	LeastPrivilegeMode
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-LicenseType

Jenis lisensi SQL Server.

Jenis:	SqlServerLicenseType
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-Location

Lokasi sumber daya.

Jenis:	String
Position:	Named
Nilai default:	None
Diperlukan:	True
Terima input alur:	False
Terima karakter wildcard:	False

-Name

Nama komputer virtual SQL.

Jenis:	String
Alias:	SqlVirtualMachineName, SqlVMName
Position:	Named
Nilai default:	None
Diperlukan:	True
Terima input alur:	False
Terima karakter wildcard:	False

-NoWait

Jalankan perintah secara asinkron

Jenis:	SwitchParameter
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-Offer

Penawaran gambar SQL. Contohnya termasuk SQL2016-WS2016, SQL2017-WS2016.

Jenis:	String
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-ResourceGroupName

Nama grup sumber daya yang berisi sumber daya. Anda dapat memperoleh nilai ini dari API Azure Resource Manager atau portal.

Jenis:	String
Position:	Named
Nilai default:	None
Diperlukan:	True
Terima input alur:	False
Terima karakter wildcard:	False

-ScheduleDayOfWeek

Hari dalam seminggu untuk menjalankan penilaian.

Jenis:	AssessmentDayOfWeek
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-ScheduleEnable

Aktifkan atau nonaktifkan jadwal penilaian pada komputer virtual SQL.

Jenis:	SwitchParameter
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-ScheduleMonthlyOccurrence

Terjadinya hari DayOfWeek dalam sebulan untuk menjadwalkan penilaian. Mengambil nilai: 1,2,3,4 dan -1. Gunakan -1 untuk hari DayOfWeek terakhir dalam sebulan

Jenis:	Int32
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-ScheduleStartTime

Waktu dalam format HH:mm. Misalnya. 17:30

Jenis:	String
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-ScheduleWeeklyInterval

Jumlah minggu yang akan dijadwalkan antara 2 penilaian berjalan. Mengambil nilai dari 1-6

Jenis:	Int32
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-Sku

Jenis edisi SQL Server.

Jenis:	SqlImageSku
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SqlConnectivityUpdateSettingConnectivityType

Opsi konektivitas SQL Server.

Jenis:	ConnectivityType
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SqlConnectivityUpdateSettingPort

Port SQL Server.

Jenis:	Int32
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SqlConnectivityUpdateSettingSqlAuthUpdatePassword

Kata sandi masuk SQL Server sysadmin.

Jenis:	SecureString
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SqlConnectivityUpdateSettingSqlAuthUpdateUserName

Masuk SQL Server sysadmin untuk dibuat.

Jenis:	String
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SqlDataSettingDefaultFilePath

Jalur file default SQL Server

Jenis:	String
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SqlDataSettingLun

Nomor Unit Logis untuk disk.

Jenis:	Int32[]
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SqlInstanceSettingCollation

Kolase SQL Server.

Jenis:	String
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SqlInstanceSettingIsIfiEnabled

SQL Server IFI.

Jenis:	SwitchParameter
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SqlInstanceSettingIsLpimEnabled

SQL Server LPIM.

Jenis:	SwitchParameter
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SqlInstanceSettingIsOptimizeForAdHocWorkloadsEnabled

SQL Server Optimize untuk beban kerja Adhoc.

Jenis:	SwitchParameter
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SqlInstanceSettingMaxDop

SQL Server MAXDOP.

Jenis:	Int32
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SqlInstanceSettingMaxServerMemoryMb

Memori maksimum SQL Server.

Jenis:	Int32
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SqlInstanceSettingMinServerMemoryMb

Memori minimum SQL Server.

Jenis:	Int32
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SqlLogSettingDefaultFilePath

Jalur file default SQL Server

Jenis:	String
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SqlLogSettingLun

Nomor Unit Logis untuk disk.

Jenis:	Int32[]
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SqlManagementType

Jenis Manajemen SQL Server.

Jenis:	SqlManagementMode
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SqlStorageUpdateSettingDiskConfigurationType

Konfigurasi disk untuk diterapkan ke SQL Server.

Jenis:	DiskConfigurationType
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SqlStorageUpdateSettingDiskCount

Jumlah disk komputer virtual.

Jenis:	Int32
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SqlStorageUpdateSettingStartingDeviceId

Id perangkat dari disk pertama yang akan diperbarui.

Jenis:	Int32
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SqlTempDbSettingDataFileCount

Jumlah file data tempdb SQL Server

Jenis:	Int32
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SqlTempDbSettingDataFileSize

Ukuran file data tempdb SQL Server

Jenis:	Int32
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SqlTempDbSettingDataGrowth

Ukuran penyebaran otomatis file data tempdb SQL Server

Jenis:	Int32
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SqlTempDbSettingDefaultFilePath

Jalur file default SQL Server

Jenis:	String
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SqlTempDbSettingLogFileSize

Ukuran file log tempdb SQL Server

Jenis:	Int32
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SqlTempDbSettingLogGrowth

Ukuran file log tempdb SQL Server autoGrowth

Jenis:	Int32
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SqlTempDbSettingLun

Nomor Unit Logis untuk disk.

Jenis:	Int32[]
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SqlTempDbSettingPersistFolder

SQL Server tempdb mempertahankan pilihan folder

Jenis:	SwitchParameter
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SqlTempDbSettingPersistFolderPath

Lokasi folder tempdb SQL Server bertahan

Jenis:	String
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SqlVirtualMachineGroupResourceId

Id sumber daya ARM dari grup komputer virtual SQL komputer virtual SQL ini adalah atau akan menjadi bagian dari.

Jenis:	String
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SqlWorkloadTypeUpdateSettingSqlWorkloadType

Jenis beban kerja SQL Server.

Jenis:	SqlWorkloadType
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-StorageConfigurationSettingDiskConfigurationType

Konfigurasi disk untuk diterapkan ke SQL Server.

Jenis:	DiskConfigurationType
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-StorageConfigurationSettingSqlSystemDbOnDataDisk

Penyimpanan SQL Server SystemDb di DataPool jika benar.

Jenis:	SwitchParameter
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-StorageConfigurationSettingStorageWorkloadType

Jenis beban kerja penyimpanan.

Jenis:	StorageWorkloadType
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-SubscriptionId

ID Langganan yang mengidentifikasi langganan Azure.

Jenis:	String
Position:	Named
Nilai default:	(Get-AzContext).Subscription.Id
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-Tag

Tag sumber daya.

Jenis:	Hashtable
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-WhatIf

Menunjukkan apa yang akan terjadi jika cmdlet berjalan. Cmdlet tidak dijalankan.

Jenis:	SwitchParameter
Alias:	wi
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-WsfcDomainCredentialsClusterBootstrapAccountPassword

Kata sandi akun bootstrap kluster.

Jenis:	SecureString
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-WsfcDomainCredentialsClusterOperatorAccountPassword

Kata sandi akun operator kluster.

Jenis:	SecureString
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-WsfcDomainCredentialsSqlServiceAccountPassword

Kata sandi akun layanan SQL.

Jenis:	SecureString
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

-WsfcStaticIP

Kredensial domain untuk menyiapkan Kluster Failover Windows Server untuk grup ketersediaan SQL.

Jenis:	String
Position:	Named
Nilai default:	None
Diperlukan:	False
Terima input alur:	False
Terima karakter wildcard:	False

Output

ISqlVirtualMachine