The Azure Quickstart templates are currently available in English
SQL Server 2014 SP2 Enterprise with Auto Backup
Última actualización: 01/10/2020
This template will create a SQL Server 2014 SP2 Enterprise edition with Auto Backup feature enabled
Esta plantilla de Azure Resource Manager (ARM) la creó un miembro de la comunidad, no Microsoft. Su propietario (no Microsoft) le permite usar las plantillas de ARM con arreglo a un contrato de licencia. Microsoft no se responsabiliza de ninguna plantilla de ARM que le proporcionen los miembros de la comunidad (o cuya licencia le otorguen) en cuanto a su seguridad, compatibilidad ni rendimiento. Las plantillas de ARM de la comunidad no reciben ningún tipo de soporte en ningún servicio ni programa de soporte de Microsoft. Dichas plantillas se proporcionan TAL CUAL, sin garantía de ningún tipo.
Parámetros
| Nombre del parámetro | Descripción |
|---|---|
| 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 |
| 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 |
| sqlAutobackupRetentionPeriod | SQL Server Auto Backup Retention Period |
| sqlAutobackupStorageAccountName | SQL Server Auto Backup Storage Account Name |
| sqlAutobackupEncryptionPassword | SQL Server Auto Backup Encryption Password |
| sqlAuthenticationLogin | SQL Server Authentication Login Account Name |
| sqlAuthenticationPassword | SQL Server Authentication Login Account Password |
| location | Location for all resources. |
| _artifactsLocation | URI to artifacts location |
| _artifactsLocationSasToken | The sasToken required to access _artifactsLocation. When the template is deployed using the accompanying scripts, a sasToken will be automatically generated |
Uso de la plantilla
PowerShell
New-AzResourceGroup -Name <resource-group-name> -Location <resource-group-location> #use this command when you need to create a new resource group for your deploymentInstalar y configurar PowerShell de Azure
New-AzResourceGroupDeployment -ResourceGroupName <resource-group-name> -TemplateUri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/201-vm-sql-full-autobackup/azuredeploy.json
Línea de comandos
az group create --name <resource-group-name> --location <resource-group-location> #use this command when you need to create a new resource group for your deploymentInstalación y configuración de la interfaz de línea de comandos multiplataforma de Azure
az group deployment create --resource-group <my-resource-group> --template-uri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/201-vm-sql-full-autobackup/azuredeploy.json