Back to Azure Resource templates index <–
Use an Azure failovergroup for disaster and recovery of SQL databases.
Template Locations
Infrastructure As Code Advisor (Beta)
WAF-compliance
The WAF-compliance advisor validates templates based on the Well Architected Framework practices. Every day a GitHub Action updates the templates compliance data and lists the recomendations.
Sustainbility Advisor
The sustainability advisor is based on the Sogeti Cloud Reference Architecture with sustainble practices. These sustainble practices cover application code, cloud infrastructures and data. The global Sogeti community is continously evolving the sustainble practices and every day new and tuned are added. For cloud infrastructures the sustainble practices are automatically validated and reported below.
note: when 100% it can be that there is no sustainble practices yet for this Cloud infrastructure.
Online documentation
Template reference
Service description
Requirements
- Resource group must been created with a valid name and location.
- Before deploying an Azure fail over group you need to have a primary sql server and sql database in place, and a secondary sql server in another region than the primary sql server.
Input values
- tagBillingIdentifier : BillingIdentifier tag.
-
sqsPrimaryName : The name of the primary sql server - fogPartnerServersId : The resourceid of the secondary sql server.
- sdbDatabases : List of resourceid’s van databases in the fail over group
- sqsFailoverPolicy Automatic or Manual
- sqsFailoverWithDataLossGracePeriodMinutes : Grace period before fail over with data loss is attempted for the read-write endpoint. If failoverPolicy is Automatic then fail over WithDataLossGracePeriodMinutes is required.
Output values
- sqsFailoverGroupName
- sqsFailoverGroupId
Additional information
First, deploy a SQL server (primary) and SQL database (primary) in one location using the templates sqlserver and sqldatabase. Then deploy a SQL server (secondary) in another region using the sqlserver template. You then deploy a failovergroup using the template sqlserverwithfailover. The sqlserverwithfailover template links the primary and secondary server together and adds the database to the failover group.
Compliance Advisor details
Resource Health Result
| Message | ResourceType | Severity |
|---|---|---|
| It is recommended to use tags for your resource, which is currently missing | Microsoft.Sql/servers/failoverGroups | 1 |
| To help other contributors understand the purpose of the resource, specify comments for each resource in the template | Microsoft.Sql/servers/failoverGroups | 1 |
| It is recommended to parameterized your tag and make it as object type | Microsoft.Sql/servers/failoverGroups | 1 |
TemplateParameterHealthResult
| Message | Severity |
|---|---|
| Define default values for parameters that aren't sensitive. By specifying a default value, it's easier to deploy the template, and users of your template see an example of an appropriate value i.e. sqsPrimaryNameRead More | 1 |
| Define default values for parameters that aren't sensitive. By specifying a default value, it's easier to deploy the template, and users of your template see an example of an appropriate value i.e. fogPartnerServersIdRead More | 1 |
| Define default values for parameters that aren't sensitive. By specifying a default value, it's easier to deploy the template, and users of your template see an example of an appropriate value i.e. sdbDatabasesRead More | 1 |
TemplateVariableHealthResult
| Message | Severity |
|---|---|
| It is recommended to make your variable as camel case, wherever possible for e.g. environmentRead More | 1 |
TemplateOthersHealthResult
| Message | Severity |
|---|---|
| Current schema version is not valid, Please change the version year to 2019-04-01 or greater | 2 |