Terraform: 101-vm-sql-existing-autobackup-update


Kiran Patnayakuni   |   Co-authors:  Anusha DokulaVeeresh Setty

Configure SQL Server Automated Backup on any existing Azure virtual machine running SQL Server 2014 Enterprise and Standard

Description

This is an Azure quickstart sample terraform configuration based on ARM template 101-vm-sql-existing-autobackup-update  from the repository azure\azure-quickstart-templates .

This configuration can be used for any Azure virtual machine running SQL Server 2014 Enterprise or Standard Edition.

The Automated Backup feature can be used to configure an automated backup schedule for SQL databases on an Azure virtual machine running SQL Server.Automated Backup is supported in your virtual machine through the SQL Server IaaS Agent extension.

This configuration can be used to enable or change the configuration of Automated backup. Please ensure you have already deployed the prerequisite preq

If you wish to disable Automated Backup, then you can edit main.tf and set “Enable” to false.

Note:

Before deploying this configuration, import the existing azure vm extension into the terraform state file to manage that resource by terraform. ex: terraform import azurerm_virtual_machine_extension.azex-01 < resource id >

Syntax

# To initialize the configuration directory
PS C:\Terraform\101-vm-sql-existing-autobackup-update> terraform init 

# To check the execution plan
PS C:\Terraform\101-vm-sql-existing-autobackup-update> terraform plan

# To deploy the configuration
PS C:\Terraform\101-vm-sql-existing-autobackup-update> terraform apply

Example

# Initialize
PS C:\Terraform\101-vm-sql-existing-autobackup-update> terraform init 

# Plan
PS C:\Terraform\101-vm-sql-existing-autobackup-update> terraform plan -var="existingVirtualMachineName=ExistingWinvm" -var="resourceGroupName=demo-rg" -var="sqlAutobackupStorageAccountName=cpr3bxp5yb6umstorage1"

var.sqlAutobackupEncryptionPassword
SQL Server Auto Backup Encryption Password
Enter a value: ******

<--- output truncated --->

# Apply
PS C:\Terraform\101-vm-sql-existing-autobackup-update> terraform apply  -var="existingVirtualMachineName=ExistingWinvm" -var="resourceGroupName=demo-rg" -var="sqlAutobackupStorageAccountName=cpr3bxp5yb6umstorage1"

var.sqlAutobackupEncryptionPassword
SQL Server Auto Backup Encryption Password
Enter a value: ******

Output

data.azurerm_storage_account.asa-01: Refreshing state...
azurerm_virtual_machine_extension.avm-ext-01: Creating...

<--- output truncated --->

azurerm_virtual_machine_extension.avm-ext-01: Creation complete after 3m10s

Apply complete! Resources: 1 added, 0 changed, 0 destroyed.

Code

    View the code in GitHub  
Last modified: 29 September 2020

Share it on     |   |   |   | 
comments powered by Disqus