Configure active geo-replication

To configure active geo-replication in Microsoft Azure SQL Solution, you can follow these steps:

Step 1: Create a Source and Target Database

You need to create a source database and a target database in Azure SQL. The source database will act as the primary database, and the target database will be the secondary database in a different region.

Step 2: Enable Active Geo-Replication

To enable active geo-replication for your databases, you can use the Azure portal, PowerShell, or Azure CLI.

Using the Azure portal:

1. Open the Azure portal and navigate to your source database.
2. In the left menu, select “Geo-Replication.”
3. Click on “Add Secondary” and select your target database.
4. Choose the target region for your secondary database and click “OK.”
5. Click on “Apply.”

Using PowerShell:

$primaryServer = ‘.database.windows.net’
$secondaryServer = ‘.database.windows.net’
$primaryDatabase = ‘‘
$secondaryDatabase = ‘‘
$resourceGroupName = ‘‘
$subscriptionId = ‘‘

Set-AzSqlDatabaseSecondary -ResourceGroupName $resourceGroupName `
-ServerName $primaryServer -DatabaseName $primaryDatabase `
-PartnerResourceGroupName $resourceGroupName `
-PartnerServerName $secondaryServer -PartnerDatabaseName $secondaryDatabase `
-SecondaryType GeoDRDatabase `
-SubscriptionId $subscriptionId

Using Azure CLI:

az sql db replica create –name –partner-resource-group –partner-server –partner-database–server–resource-group

Step 3: Monitor Active Geo-Replication

You can monitor the active geo-replication status and progress using the Azure portal, PowerShell, or Azure CLI.

Using the Azure portal:

1. Open the Azure portal and navigate to your source database.
2. In the left menu, select “Geo-Replication.”
3. You can view the replication status and lag time in the portal.

Using PowerShell:

$primaryServer = ‘.database.windows.net’
$primaryDatabase = ‘‘
$resourceGroupName = ‘‘

$geoReplication = Get-AzSqlDatabaseGeoBackup `
-ResourceGroupName $resourceGroupName `
-ServerName $primaryServer `
-DatabaseName $primaryDatabase

$geoReplication

Using Azure CLI:

az sql db replica list-links –name–server–resource-group

Step 4: Failover and Failback

In case of a disaster or planned maintenance, you might need to failover to your secondary database or failback to the primary database. You can perform these operations using the Azure portal, PowerShell, or Azure CLI.

Using the Azure portal:

1. Open the Azure portal and navigate to your source database.
2. In the left menu, select “Geo-Replication.”
3. Click on “Failover” or “Failback” as per your requirement.

Using PowerShell:

$primaryServer = ‘.database.windows.net’
$secondaryServer = ‘.database.windows.net’
$primaryDatabase = ‘‘
$secondaryDatabase = ‘‘
$resourceGroupName = ‘‘

Failover-AzSqlDatabaseSecondary -ResourceGroupName $resourceGroupName `
-ServerName $primaryServer -DatabaseName $primaryDatabase `
-PartnerResourceGroupName $resourceGroupName `
-PartnerServerName $secondaryServer -PartnerDatabaseName $secondaryDatabase

Failover-AzSqlDatabaseSecondary -ResourceGroupName $resourceGroupName `
-ServerName $secondaryServer -DatabaseName $secondaryDatabase `
-PartnerResourceGroupName $resourceGroupName `
-PartnerServerName $primaryServer -PartnerDatabaseName $primaryDatabase

Using Azure CLI:

az sql db replica set-primary –server –name –resource-group

By following these steps and using the Azure portal, PowerShell, or Azure CLI, you can easily configure and manage active geo-replication for your Azure SQL Solution. This ensures high availability and disaster recovery for your databases across different regions.