Provision a database programmatically in Azure SQL database with a failover group
Tags: sqlserver, dotnet, microsoftazure, azure
Published: 2024-01-24 16:27:10

---
title: Provision a database programmatically in Azure SQL database with a failover group
published: true
date: 2024-01-24 14:32:24 UTC
tags: SqlServer,DotNET,MicrosoftAzure,azure
canonical_url: https://blogit.create.pt/miguelisidoro/2024/01/24/provision-a-database-programmatically-in-azure-sql-database-with-a-failover-group/
---

This post will explain how to provision a database programmatically in a Azure SQL database and add it to an Azure SQL failover group.

## Introduction

An Azure SQL Server failover group is a group of databases that can be automatically or manually failed over from a primary server to a secondary server in a different Azure region in case of a disaster in the primary server. Failover groups provide high availability and disaster recovery for Azure SQL Server databases.

The process described in this post is composed by two main steps:

- Provisioning the database
- Adding the database to the failover group 

## Provisioning the database

The first step is to create the database. This step is composed by the following actions:

- Get the tenant information
- Create the database

Tenant information class:

![](https://blogit.create.pt/wp-content/uploads/2024/01/Regions.jpg)

Code to create database programatically:

![](https://blogit.create.pt/wp-content/uploads/2024/01/CreateDatabase-1024x722.jpg)

## Adding the database to the failover group

The second step adds the newly created database to the failover group. This step is composed by the following actions:

- Get the failover group where we want to add the database
- Re-add the existing databases to the failover group – necessary since when we get the failover group the list of databases of the group is empty and, without this step, the failover group would only have the new database
- Add the new database to the failover group

![](https://blogit.create.pt/wp-content/uploads/2024/01/Failovergroup.jpg)

## Other Articles

To learn why your business should migrate to SharePoint Online and Office 365, click [here](https://blogit.create.pt////miguelisidoro/2019/07/29/why-your-business-should-migrate-to-sharepoint-online-and-office-365-the-value-offer-part-1/) and [here](https://blogit.create.pt////miguelisidoro/2019/07/29/why-your-business-should-migrate-to-sharepoint-online-and-office-365-the-value-offer-part-2/).

If you want to learn how to develop SPFx solutions, click [here](https://dev.to/mlisidoro/sharepoint-framework-spfx-learning-guide-k8d-temp-slug-3333313).

If you want to learn how you can rename a modern SharePoint site, click [here](https://blogit.create.pt////miguelisidoro/2019/09/23/how-to-rename-a-modern-sharepoint-site-url-in-office-365/).

If you want to learn how to save time time scheduling your meetings, click [here](https://blogit.create.pt////miguelisidoro/2020/04/12/save-time-scheduling-microsoft-teams-meetings-using-findtime/).

If you want to learn how to enable Microsoft Teams Attendance List Download, click [here](https://blogit.create.pt////miguelisidoro/2020/09/20/how-to-enable-teams-meeting-attendance-list-download-in-microsoft-365/).

If you want to learn how to create a dynamic org-wide team in Microsoft Teams with all active employees, click [here](https://blogit.create.pt/miguelisidoro/2020/09/21/how-to-create-a-dynamic-team-in-microsoft-teams-with-all-active-employees-in-microsoft-365/).

If you want to modernize your SharePoint classic root site to a modern SharePoint site, click [here](https://blogit.create.pt////miguelisidoro/2019/08/27/how-to-modernize-your-tenant-root-site-collection-in-office-365-using-invoke-spositeswap/).

If you are a SharePoint administrator or a SharePoint developer who wants to learn more about how to install a SharePoint 2019 farm in an automated way using PowerShell, I invite you to click [here](https://blogit.create.pt////miguelisidoro/2018/12/09/how-to-install-a-sharepoint-2019-farm-using-powershell-and-autospinstaller-part-1/) and [here](https://blogit.create.pt////miguelisidoro/2018/12/09/how-to-install-a-sharepoint-2019-farm-using-powershell-and-autospinstaller-part-2/).

If you learn how to greatly speed up your SharePoint farm update process to ensure your SharePoint farm keeps updated and you stay one step closer to start your move to the cloud, click [here](https://blogit.create.pt////miguelisidoro/2019/05/02/how-to-speed-up-the-installation-of-sharepoint-cumulative-updates-using-powershell-step-by-step/).

If you prefer to use the traditional method to update your farm and want to learn all the steps and precautions necessary to successfully keep your SharePoint farm updated, click [here](https://blogit.create.pt////miguelisidoro/2019/04/08/how-to-install-sharepoint-cumulative-updates-in-a-sharepoint-farm-step-by-step/).

If you want to learn how to upgrade a SharePoint 2013 farm to SharePoint 2019, click [here ](https://blogit.create.pt////miguelisidoro/2019/03/06/how-to-upgrade-from-sharepoint-2013-to-sharepoint-2019-step-by-step-part-1/)and [here](https://blogit.create.pt////miguelisidoro/2019/03/06/how-to-upgrade-from-sharepoint-2013-to-sharepoint-2019-step-by-step-part-2/).

If SharePoint 2019 is still not an option, you can learn more about how to install a SharePoint 2016 farm in an automated way using PowerShell, click [here](https://blogit.create.pt////miguelisidoro/2018/07/28/how-to-install-a-sharepoint-2016-farm-using-powershell-and-autospinstaller-part-1/) and [here](https://blogit.create.pt////miguelisidoro/2018/07/28/how-to-install-a-sharepoint-2016-farm-using-powershell-and-autospinstaller-part-2/).

If you want to learn how to upgrade a SharePoint 2010 farm to SharePoint 2016, click [here ](https://blogit.create.pt////miguelisidoro/2019/02/04/sharepoint-upgrade-upgrading-a-sharepoint-2010-farm-to-sharepoint-2016-step-by-step-part-1/)and [here](https://blogit.create.pt////miguelisidoro/2019/02/04/sharepoint-upgrade-upgrading-a-sharepoint-2010-farm-to-sharepoint-2016-step-by-step-part-2/).

If you are new to SharePoint and Office 365 and want to learn all about it, take a look at these [learning resources](https://blogit.create.pt////miguelisidoro/2018/10/17/sharepoint-and-office-365-learning-resources/).

If you are work in a large organization who is using Office 365 or thinking to move to Office 365 and is considering between a single or multiple Office 365 tenants, I invite you to read [this article](https://blogit.create.pt////miguelisidoro/2019/01/07/pros-and-cons-of-single-tenant-vs-multiple-tenants-in-office-365/).

If you want to know all about the latest SharePoint and Office 365 announcements from Ignite and some more recent announcements, including Microsoft Search, What’s New to Build a Modern Intranet with SharePoint in Office 365, Deeper Integration between Microsoft Teams and SharePoint and the latest news on SharePoint development, click [here](https://blogit.create.pt////miguelisidoro/2018/11/21/whats-new-for-sharepoint-and-office-365-after-microsoft-ignite-2018/).

If your organization is still not ready to go all in to SharePoint Online and Office 365, a hybrid scenario may be the best choice. SharePoint 2019 RTM was recently announced and if you to learn all about SharePoint 2019 and all its features, click [here](https://blogit.create.pt////miguelisidoro/2018/11/01/meet-the-new-modern-sharepoint-server-sharepoint-2019-rtm-is-here/).

Happy Coding!

The post [Provision a database programmatically in Azure SQL database with a failover group](https://blogit.create.pt/miguelisidoro/2024/01/24/provision-a-database-programmatically-in-azure-sql-database-with-a-failover-group/) appeared first on [Blog IT](https://blogit.create.pt).