This template will create a SQL Server 2014 SP1 Enterprise edition with Auto Patching, Auto Backup and Azure Key Vault Integration features enabled.
Bu Azure Resource Manager (ARM) şablonu Microsoft tarafından değil bir topluluk üyesi tarafından oluşturulmuştur. Her bir ARM şablonu size Microsoft tarafından değil, bir lisans sözleşmesi altında sahibi tarafından lisanslanmıştır. Microsoft, topluluk üyeleri tarafından sağlanan ve lisanslanan ARM şablonlarından sorumlu değildir ve güvenlik, uyumluluk ve performans denetimi yapmaz. Topluluk ARM şablonları herhangi bir Microsoft destek programı veya hizmeti altında desteklenmez ve herhangi bir garanti olmaksızın OLDUĞU GİBİ kullanıma sunulur.
Parametreler
| Parametre Adı | Açıklama |
|---|---|
| virtualMachineName | SQL Server Virtual Machine Name |
| virtualMachineSize | SQL Server Virtual Machine Size |
| adminUsername | SQL Server Virtual Machine Administrator User Name |
| adminPassword | SQL Server Virtual Machine Administrator Password |
| storageAccountName | SQL Server Virtual Machine Storage Account Name |
| storageAccountType | SQL Server Virtual Machine Storage Account Type |
| virtualNetworkName | SQL Server Virtual Machine Virtual Network Name |
| networkInterfaceName | SQL Server Virtual Machine Network Interface Name |
| networkSecurityGroupName | SQL Server Virtual Machine Network Security Group Name |
| addressPrefix | SQL Server Virtual Machine Subnet Name |
| subnetName | SQL Server Virtual Machine Subnet Name |
| subnetPrefix | SQL Server Virtual Machine Subnet Name |
| publicIpAddressName | SQL Server Virtual Machine Public IP Address Name |
| publicIpAddressType | SQL Server Virtual Machine Public IP Address Type |
| sqlConnectivityType | SQL Server Virtual Machine SQL Connectivity Type |
| sqlPortNumber | SQL Server Virtual Machine SQL Port Number |
| sqlStorageDisksCount | SQL Server Virtual Machine Data Disk Count |
| sqlStorageWorkloadType | SQL Server Virtual Machine Workload Type: GENERAL - general work load; DW - datawear house work load; OLTP - Transactional processing work load |
| sqlAutopatchingDayOfWeek | SQL Server Auto Patching Day of A Week |
| sqlAutopatchingStartHour | SQL Server Auto Patching Starting Hour |
| sqlAutopatchingWindowDuration | SQL Server Auto Patching Duration Window in minutes |
| sqlAutobackupRetentionPeriod | SQL Server Auto Backup Retention Period |
| sqlAutobackupStorageAccountName | SQL Server Auto Backup Storage Account Name |
| sqlAutobackupEncryptionPassword | SQL Server Auto Backup Encryption Password |
| sqlAkvCredentialName | SQL credential name to create on the SQL Server virtual machine |
| sqlAkvUrl | Azure Key Vault URL |
| sqlAkvPrincipalName | Azure Key Vault principal name or id |
| sqlAkvPrincipalSecret | Azure Key Vault principal secret |
| sqlAuthenticationLogin | SQL Server Authentication Login Account Name |
| sqlAuthenticationPassword | SQL Server Authentication Login Account Password |
| location | Location for all resources. |
Şablonu kullanın
PowerShell
New-AzureRmResourceGroupDeployment -Name <deployment-name> -ResourceGroupName <resource-group-name> -TemplateUri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/301-vm-sql-full-autobackup-autopatching-keyvault/azuredeploy.jsonAzure PowerShell'i yükleme ve yapılandırma
Komut satırı
azure config mode armAzure Platformlar Arası Komut Satırı Arabirimini Yükleme ve Yapılandırma
azure group deployment create <my-resource-group> <my-deployment-name> --template-uri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/301-vm-sql-full-autobackup-autopatching-keyvault/azuredeploy.json