教程：将 Azure SQL 数据库添加到自动故障转移组Tutorial: Add an Azure SQL Database to an autofailover group

若要完成本教程，请确保做好以下准备：To complete this tutorial, make sure you have:

• Azure 订阅。An Azure subscription. 创建一个试用版订阅（如果还没有）。Create a Trial Subscription if you don't already have one.

若要完成本教程，请确保准备好以下各项：To complete the tutorial, make sure you have the following items:

• Azure 订阅。An Azure subscription. 创建一个试用版订阅（如果还没有）。Create a Trial Subscription if you don't already have one.
• Azure PowerShellAzure PowerShell

若要完成本教程，请确保准备好以下各项：To complete the tutorial, make sure you have the following items:

• Azure 订阅。An Azure subscription. 创建一个试用版订阅（如果还没有）。Create a Trial Subscription if you don't already have one.
• 最新版本的 Azure CLI。The latest version of the Azure CLI.

若要在 Azure 门户中创建资源组、服务器和单一数据库，请执行以下操作：To create a resource group, server, and single database in the Azure portal:

1. 登录门户。Sign in to the portal.

2. 在搜索栏中，搜索并选择“SQL 数据库”。From the Search bar, search for and select SQL database.

3. 选择“创建” 。Select Create.

   

4. 在“创建 SQL 数据库”窗体的“基本信息”选项卡上的“项目详细信息”下，选择正确的 Azure订阅（如果尚未选择）。On the Basics tab of the Create SQL database form, under Project details, select the correct Azure Subscription if it isn't already selected.

5. 在“资源组”下选择“新建”，输入“MyResourceGroup”，然后选择“确定” 。Under Resource group, select Create new, enter myResourceGroup, and select OK.

6. 在“数据库详细信息”下，为“数据库名称”输入“mySampleDatabase”。Under Database details, for Database name enter mySampleDatabase.

7. 对于“服务器”，选择“新建”，并按如下所示在“新服务器”窗体中填写信息：For Server, select Create new, and fill out the New server form as follows:

   • 服务器名称：输入“mysqlserver”和一些字符以实现唯一性。Server name: Enter mysqlserver, and some characters for uniqueness.
   • 服务器管理员登录名：输入“azureuser”。Server admin login: Enter azureuser.
   • 密码：输入符合要求的密码，然后在“确认密码”字段中再次输入该密码。Password: Enter a password that meets requirements, and enter it again in the Confirm password field.
   • 位置：单击下拉箭头并选择一个位置，例如“中国东部 2”。Location: Drop down and choose a location, such as China East 2.

   选择“确定” 。Select OK.

   

   请记录服务器管理员登录名和密码，以便可以登录服务器及其数据库。Record the server admin login and password so you can log in to the server and its databases. 如果忘记了登录名或密码，那么在数据库创建之后，可在“SQL 服务器”页上获取登录名或重置密码。If you forget your login or password, you can get the login name or reset the password on the SQL server page after database creation. 若要打开“SQL 服务器”页，请在数据库“概述”页上选择服务器名称 。To open the SQL server page, select the server name on the database Overview page.

8. 在“计算 + 存储”下，若要重新配置默认值，请选择“配置数据库”。Under Compute + storage, if you want to reconfigure the defaults, select Configure database.

   在“配置”页上，可以选择：On the Configure page, you can optionally:

   • 将“计算层”从“预配”更改为“无服务器”。Change the Compute tier from Provisioned to Serverless.
   • 查看并更改“Vcore”和“数据最大大小”设置 。Review and change the settings for vCores and Data max size.
   • 选择“更改配置”来更改硬件代系。Select Change configuration to change the hardware generation.

   进行更改后，请选择“应用”。After making any changes, select Apply.

9. 在完成时选择“下一步:网络”。Select Next: Networking at the bottom of the page.

   

10. 在“网络”选项卡上的“连接方法”下，选择“公共终结点”。On the Networking tab, under Connectivity method, select Public endpoint.

11. 在“防火墙规则”下，将“添加当前客户端 IP 地址”设置为“是”。Under Firewall rules, set Add current client IP address to Yes.

12. 在完成时选择“下一步:其他设置”。Select Next: Additional settings at the bottom of the page.

    

    有关防火墙设置的详细信息，请参阅允许 Azure 服务和资源访问此服务器和添加专用终结点。For more information about firewall settings, see Allow Azure services and resources to access this server and Add a private endpoint.

13. 在“其他设置”选项卡上的“数据源”部分中，对于“使用现有数据”，请选择“示例”。On the Additional settings tab, in the Data source section, for Use existing data, select Sample.

14. （可选）启用 Azure Defender for SQL。Optionally, enable Azure Defender for SQL.

15. 在页面底部选择“查看 + 创建”。Select Review + create at the bottom of the page.

    

16. 查看设置后，选择“创建”。After reviewing settings, select Create.

可以使用 Azure 命令行接口 (Azure CLI) 创建 Azure 资源组、服务器和单一数据库。You can create an Azure resource group, server, and single database using the Azure command-line interface (Azure CLI). 在计算机上安装 Azure CLI。Install Azure CLI on your computer.

以下 Azure CLI 代码将创建用于访问服务器的资源组、服务器、单一数据库和服务器级 IP 防火墙规则。The following Azure CLI code creates a resource group, server, single database, and server-level IP firewall rule for access to the server. 请确保记录生成的资源组和服务器名称，以便可以在以后管理这些资源。Make sure to record the generated resource group and server names, so you can manage these resources later.

#!/bin/bash

# Sign in to Azure and set execution context (if necessary)
az login
az account set --subscription <Subscription ID>

# Set the resource group name and location for your server
resourceGroupName=myResourceGroup-$RANDOM
location=chinaeast2

# Set an admin login and password for your database
adminlogin=azureuser
password=Azure1234567

# Set a server name that is unique to Azure DNS (<server_name>.database.chinacloudapi.cn)
servername=server-$RANDOM

# Set the ip address range that can access your database
startip=0.0.0.0
endip=0.0.0.0

# Create a resource group
az group create \
    --name $resourceGroupName \
    --location $location

# Create a server in the resource group
az sql server create \
    --name $servername \
    --resource-group $resourceGroupName \
    --location $location  \
    --admin-user $adminlogin \
    --admin-password $password

# Configure a server-level firewall rule for the server
az sql server firewall-rule create \
    --resource-group $resourceGroupName \
    --server $servername \
    -n AllowYourIp \
    --start-ip-address $startip \
    --end-ip-address $endip

# Create a gen5 2 vCore database in the server
az sql db create \
    --resource-group $resourceGroupName \
    --server $servername \
    --name mySampleDatabase \
    --sample-name AdventureWorksLT \
    --edition GeneralPurpose \
    --family Gen5 \
    --capacity 2 \

前面的代码使用以下 Azure CLI 命令：The preceding code uses these Azure CLI commands:

若要查看更多 Azure SQL Database Azure CLI 示例，请参阅 Azure CLI 示例。For more Azure SQL Database Azure CLI samples, see Azure CLI samples.

可以使用 Windows PowerShell 创建资源组、服务器和单一数据库。You can create a resource group, server, and single database using Windows PowerShell. 如果不想使用 Azure Cloud Shell，请安装 Azure PowerShell 模块。If you don't want to use the Azure Cloud Shell, install the Azure PowerShell module.

以下 PowerShell 代码将创建用于访问服务器的 Azure 资源组、服务器、单一数据库和防火墙规则。The following PowerShell code creates an Azure resource group, server, single database, and firewall rule for access to the server. 请确保记录生成的资源组和服务器名称，以便可以在以后管理这些资源。Make sure to record the generated resource group and server names, so you can manage these resources later.

# Set variables for your server and database
$subscriptionId = '<SubscriptionID>'
$resourceGroupName = "myResourceGroup-$(Get-Random)"
$location = "China East 2"
$adminLogin = "azureuser"
$password = "Azure1234567"
$serverName = "mysqlserver-$(Get-Random)"
$databaseName = "mySampleDatabase"

# The ip address range that you want to allow to access your server
$startIp = "0.0.0.0"
$endIp = "0.0.0.0"

# Show randomized variables
Write-host "Resource group name is" $resourceGroupName
Write-host "Server name is" $serverName

# Connect to Azure
Connect-AzAccount -Environment AzureChinaCloud

# Set subscription ID
Set-AzContext -SubscriptionId $subscriptionId

# Create a resource group
Write-host "Creating resource group..."
$resourceGroup = New-AzResourceGroup -Name $resourceGroupName -Location $location -Tag @{Owner="SQLDB-Samples"}
$resourceGroup

# Create a server with a system wide unique server name
Write-host "Creating primary server..."
$server = New-AzSqlServer -ResourceGroupName $resourceGroupName `
   -ServerName $serverName `
   -Location $location `
   -SqlAdministratorCredentials $(New-Object -TypeName System.Management.Automation.PSCredential `
   -ArgumentList $adminLogin, $(ConvertTo-SecureString -String $password -AsPlainText -Force))
$server

# Create a server firewall rule that allows access from the specified IP range
Write-host "Configuring firewall for primary server..."
$serverFirewallRule = New-AzSqlServerFirewallRule -ResourceGroupName $resourceGroupName `
   -ServerName $serverName `
   -FirewallRuleName "AllowedIPs" -StartIpAddress $startIp -EndIpAddress $endIp
$serverFirewallRule

# Create General Purpose Gen4 database with 1 vCore
Write-host "Creating a gen5 2 vCore database..."
$database = New-AzSqlDatabase  -ResourceGroupName $resourceGroupName `
   -ServerName $serverName `
   -DatabaseName $databaseName `
   -Edition GeneralPurpose `
   -VCore 2 `
   -ComputeGeneration Gen5 `
   -MinimumCapacity 2 `
   -SampleName "AdventureWorksLT"
$database

前面的代码使用以下 PowerShell 命令：The preceding code uses these PowerShell cmdlets:

若要查看更多 Azure SQL 数据库 PowerShell 示例，请参阅 Azure PowerShell 示例。For more Azure SQL Database PowerShell samples, see Azure PowerShell samples.

使用 Azure 门户创建故障转移组，并将数据库添加到其中。Create your failover group and add your database to it using the Azure portal.

1. 在 Azure 门户的左侧菜单上选择“所有服务”。Select All Services on the left-hand menu of the Azure portal.

2. 在搜索框中键入 sql servers。Type sql servers in the search box.

3. 在 服务器名称 下选择服务器的名称以打开服务器的设置。Select the name of the server under Server name to open the settings for the server.

   

4. 在“设置”窗格下选择“故障转移组”，然后选择“添加组”以创建新的故障转移组。 Select Failover groups under the Settings pane, and then select Add group to create a new failover group.

   

5. 在“故障转移组”页上输入或选择以下值，然后选择“创建”： On the Failover Group page, enter or select the following values, and then select Create:

   • 故障转移组名称：键入唯一的故障转移组名称，例如 failovergrouptutorial。Failover group name: Type in a unique failover group name, such as failovergrouptutorial.

   • 辅助服务器：选择“配置所需设置”选项，然后选择“创建新服务器”。Secondary server: Select the option to configure required settings and then choose to Create a new server. 或者，可以选择现有的服务器作为辅助服务器。Alternatively, you can choose an already-existing server as the secondary server. 输入以下值后，选择“选择”。After entering the following values, select Select.

     • 服务器名称：键入辅助服务器的唯一名称，例如 mysqlsecondary。Server name: Type in a unique name for the secondary server, such as mysqlsecondary.
     • 服务器管理员登录名：键入 azureuserServer admin login: Type azureuser
     • 密码：键入符合密码要求的复杂密码。Password: Type a complex password that meets password requirements.
     • 位置：从下拉列表中选择一个位置，例如“中国北部 2”。Location: Choose a location from the drop-down, such as China North 2. 此位置不能与主服务器的位置相同。This location can't be the same location as your primary server.

     备注

     服务器登录名和防火墙设置必须与主服务器相匹配。The server login and firewall settings must match that of your primary server.

     

   • 组中的数据库：选择辅助服务器后，此选项将解除锁定。Databases within the group: Once a secondary server is selected, this option becomes unlocked. 使用该选项来 选择要添加的数据库：请选择在第 1 部分创建的数据库。Select it to Select databases to add and then choose the database you created in section 1. 将数据库添加到故障转移组的操作会自动启动异地复制过程。Adding the database to the failover group will automatically start the geo-replication process.

   

使用 PowerShell 创建故障转移组，并将数据库添加到其中。Create your failover group and add your database to it using PowerShell.

# $subscriptionId = '<SubscriptionID>'
# $resourceGroupName = "myResourceGroup-$(Get-Random)"
# $location = "China East 2"
# $adminLogin = "azureuser"
# $password = "PWD27!"+(New-Guid).Guid
# $serverName = "mysqlserver-$(Get-Random)"
# $databaseName = "mySampleDatabase"
$drLocation = "China North 2"
$drServerName = "mysqlsecondary-$(Get-Random)"
$failoverGroupName = "failovergrouptutorial-$(Get-Random)"

# The ip address range that you want to allow to access your server
# (leaving at 0.0.0.0 will prevent outside-of-azure connections to your DB)
$startIp = "0.0.0.0"
$endIp = "0.0.0.0"

# Show randomized variables
Write-host "DR Server name is" $drServerName
Write-host "Failover group name is" $failoverGroupName

# Create a secondary server in the failover region
Write-host "Creating a secondary server in the failover region..."
$drServer = New-AzSqlServer -ResourceGroupName $resourceGroupName `
   -ServerName $drServerName `
   -Location $drLocation `
   -SqlAdministratorCredentials $(New-Object -TypeName System.Management.Automation.PSCredential `
      -ArgumentList $adminlogin, $(ConvertTo-SecureString -String $password -AsPlainText -Force))
$drServer

# Create a server firewall rule that allows access from the specified IP range
Write-host "Configuring firewall for secondary server..."
$serverFirewallRule = New-AzSqlServerFirewallRule -ResourceGroupName $resourceGroupName `
   -ServerName $drServerName `
   -FirewallRuleName "AllowedIPs" -StartIpAddress $startIp -EndIpAddress $endIp
$serverFirewallRule

# Create a failover group between the servers
$failovergroup = Write-host "Creating a failover group between the primary and secondary server..."
New-AzSqlDatabaseFailoverGroup `
   -ResourceGroupName $resourceGroupName `
   -ServerName $serverName `
   -PartnerServerName $drServerName  `
   -FailoverGroupName $failoverGroupName `
   -FailoverPolicy Automatic `
   -GracePeriodWithDataLossHours 2
$failovergroup

# Add the database to the failover group
Write-host "Adding the database to the failover group..."
Get-AzSqlDatabase `
   -ResourceGroupName $resourceGroupName `
   -ServerName $serverName `
   -DatabaseName $databaseName | `
Add-AzSqlDatabaseToFailoverGroup `
   -ResourceGroupName $resourceGroupName `
   -ServerName $serverName `
   -FailoverGroupName $failoverGroupName
Write-host "Successfully added the database to the failover group..."

本教程的此部分使用以下 PowerShell cmdlet：This portion of the tutorial uses the following PowerShell cmdlets:

使用 Azure CLI 创建故障转移组，并将数据库添加到其中。Create your failover group and add your database to it using the Azure CLI.

#!/bin/bash
# set variables
$failoverLocation = "China East 2"
$failoverServer = "failoverServer-$randomIdentifier"
$failoverGroup = "failoverGroup-$randomIdentifier"

echo "Creating a secondary server in the DR region..."
az sql server create --name $failoverServer --resource-group $resourceGroup --location $failoverLocation --admin-user $login --admin-password $password

echo "Creating a failover group between the two servers..."
az sql failover-group create --name $failoverGroup --partner-server $failoverServer --resource-group $resourceGroup --server $server --add-db $database --failover-policy Automatic

本教程的此部分使用以下 Azure CLI cmdlet：This portion of the tutorial uses the following Azure CLI cmdlets:

使用 Azure 门户测试故障转移。Test failover using the Azure portal.

1. 在 Azure 门户中导航到你的“SQL 服务器”服务器。Navigate to your SQL servers server within the Azure portal.

2. 在“设置”窗格下选择“故障转移组”，然后选择在第 2 部分创建的故障转移组。 Select Failover groups under the Settings pane and then choose the failover group you created in section 2.

   

3. 查看哪个服务器是主服务器，哪个服务器是辅助服务器。Review which server is primary and which server is secondary.

4. 在任务窗格中选择“故障转移”，以故障转移包含你的示例数据库的故障转移组。Select Failover from the task pane to fail over your failover group containing your sample database.

5. 在告知将会断开 TDS 会话连接的警告中选择“是”。Select Yes on the warning that notifies you that TDS sessions will be disconnected.

   

6. 查看哪个服务器现在是主服务器，哪个服务器是辅助服务器。Review which server is now primary and which server is secondary. 如果故障转移成功，这两个服务器的角色应会交换。If failover succeeded, the two servers should have swapped roles.

7. 再次选择“故障转移”，使服务器恢复其原始角色。Select Failover again to fail the servers back to their original roles.

使用 PowerShell 测试故障转移。Test failover using PowerShell.

检查辅助副本的角色：Check the role of the secondary replica:

# Set variables
# $resourceGroupName = "myResourceGroup-$(Get-Random)"
# $serverName = "mysqlserver-$(Get-Random)"
# $failoverGroupName = "failovergrouptutorial-$(Get-Random)"

# Check role of secondary replica
Write-host "Confirming the secondary replica is secondary...."
(Get-AzSqlDatabaseFailoverGroup `
   -FailoverGroupName $failoverGroupName `
   -ResourceGroupName $resourceGroupName `
   -ServerName $drServerName).ReplicationRole

故障转移到辅助服务器：Fail over to the secondary server:

# Set variables
# $resourceGroupName = "myResourceGroup-$(Get-Random)"
# $serverName = "mysqlserver-$(Get-Random)"
# $failoverGroupName = "failovergrouptutorial-$(Get-Random)"

# Failover to secondary server
Write-host "Failing over failover group to the secondary..."
Switch-AzSqlDatabaseFailoverGroup `
   -ResourceGroupName $resourceGroupName `
   -ServerName $drServerName `
   -FailoverGroupName $failoverGroupName
Write-host "Failed failover group successfully to" $drServerName

将故障转移组还原到主服务器：Revert failover group back to the primary server:

# Set variables
# $resourceGroupName = "myResourceGroup-$(Get-Random)"
# $serverName = "mysqlserver-$(Get-Random)"
# $failoverGroupName = "failovergrouptutorial-$(Get-Random)"

# Revert failover to primary server
Write-host "Failing over failover group to the primary...."
Switch-AzSqlDatabaseFailoverGroup `
   -ResourceGroupName $resourceGroupName `
   -ServerName $serverName `
   -FailoverGroupName $failoverGroupName
Write-host "Failed failover group successfully back to" $serverName

本教程部分使用以下 PowerShell cmdlet：This portion of the tutorial uses the following PowerShell cmdlets:

使用 Azure CLI 测试故障转移。Test failover using the Azure CLI.

确认哪个服务器是辅助服务器：Verify which server is the secondary:

echo "Verifying which server is in the secondary role..."
az sql failover-group list --server $server --resource-group $resourceGroup

故障转移到辅助服务器：Fail over to the secondary server:

echo "Failing over group to the secondary server..."
az sql failover-group set-primary --name $failoverGroup --resource-group $resourceGroup --server $failoverServer
echo "Successfully failed failover group over to" $failoverServer

将故障转移组还原到主服务器：Revert failover group back to the primary server:

echo "Failing over group back to the primary server..."
az sql failover-group set-primary --name $failoverGroup --resource-group $resourceGroup --server $server
echo "Successfully failed failover group back to" $server

本教程的此部分使用以下 Azure CLI cmdlet：This portion of the tutorial uses the following Azure CLI cmdlets:

使用 Azure 门户删除资源组。Delete the resource group using the Azure portal.

1. 在 Azure 门户中导航到你的资源组。Navigate to your resource group in the Azure portal.
2. 选择“删除资源组”即可删除该资源组中的所有资源以及该组本身。Select Delete resource group to delete all the resources in the group, as well as the resource group itself.
3. 在文本框中键入资源组的名称 myResourceGroup，然后选择“删除”以删除该资源组。Type the name of the resource group, myResourceGroup, in the textbox, and then select Delete to delete the resource group.

使用 PowerShell 删除资源组。Delete the resource group using PowerShell.

# Set variables
# $resourceGroupName = "myResourceGroup-$(Get-Random)"

# Remove the resource group
Write-host "Removing resource group..."
Remove-AzResourceGroup -ResourceGroupName $resourceGroupName
Write-host "Resource group removed =" $resourceGroupName

本教程的此部分使用以下 PowerShell cmdlet：This portion of the tutorial uses the following PowerShell cmdlets:

使用 Azure CLI 删除资源组。Delete the resource group by using the Azure CLI.

echo "Cleaning up resources by removing the resource group..."
az group delete --name $resourceGroup
echo "Successfully removed resource group" $resourceGroup

本教程的此部分使用以下 Azure CLI cmdlet：This portion of the tutorial uses the following Azure CLI cmdlets:

# Set variables for your server and database
$subscriptionId = '<SubscriptionID>'
$randomIdentifier = $(Get-Random)
$resourceGroupName = "myResourceGroup-$randomIdentifier"
$location = "China East 2"
$adminLogin = "azureuser"
$password = "PWD27!"+(New-Guid).Guid
$serverName = "mysqlserver-$randomIdentifier"
$databaseName = "mySampleDatabase"
$drLocation = "China North 2"
$drServerName = "mysqlsecondary-$randomIdentifier"
$failoverGroupName = "failovergrouptutorial-$randomIdentifier"


# The ip address range that you want to allow to access your server 
# Leaving at 0.0.0.0 will prevent outside-of-azure connections
$startIp = "0.0.0.0"
$endIp = "0.0.0.0"

# Show randomized variables
Write-host "Resource group name is" $resourceGroupName 
Write-host "Password is" $password  
Write-host "Server name is" $serverName 
Write-host "DR Server name is" $drServerName 
Write-host "Failover group name is" $failoverGroupName

# Set subscription ID
Set-AzContext -SubscriptionId $subscriptionId

# Create a resource group
Write-host "Creating resource group..."
$resourceGroup = New-AzResourceGroup -Name $resourceGroupName -Location $location -Tag @{Owner="SQLDB-Samples"}
$resourceGroup


# Create a server with a system wide unique server name
Write-host "Creating primary logical server..."
$server = New-AzSqlServer -ResourceGroupName $resourceGroupName `
   -ServerName $serverName `
   -Location $location `
   -SqlAdministratorCredentials $(New-Object -TypeName System.Management.Automation.PSCredential `
   -ArgumentList $adminLogin, $(ConvertTo-SecureString -String $password -AsPlainText -Force))
$server

# Create a server firewall rule that allows access from the specified IP range
Write-host "Configuring firewall for primary logical server..."
$serverFirewallRule = New-AzSqlServerFirewallRule -ResourceGroupName $resourceGroupName `
   -ServerName $serverName `
   -FirewallRuleName "AllowedIPs" -StartIpAddress $startIp -EndIpAddress $endIp
$serverFirewallRule

# Create General Purpose Gen5 database with 2 vCore
Write-host "Creating a gen5 2 vCore database..."
$database = New-AzSqlDatabase  -ResourceGroupName $resourceGroupName `
   -ServerName $serverName `
   -DatabaseName $databaseName `
   -Edition GeneralPurpose `
   -VCore 2 `
   -ComputeGeneration Gen5 `
   -MinimumCapacity 2 `
   -SampleName "AdventureWorksLT"
$database

# Create a secondary server in the failover region
Write-host "Creating a secondary logical server in the failover region..."
$drServer = New-AzSqlServer -ResourceGroupName $resourceGroupName `
   -ServerName $drServerName `
   -Location $drLocation `
   -SqlAdministratorCredentials $(New-Object -TypeName System.Management.Automation.PSCredential `
      -ArgumentList $adminlogin, $(ConvertTo-SecureString -String $password -AsPlainText -Force))
$drServer


# Create a failover group between the servers
$failovergroup = Write-host "Creating a failover group between the primary and secondary server..."
New-AzSqlDatabaseFailoverGroup `
   -ResourceGroupName $resourceGroupName `
   -ServerName $serverName `
   -PartnerServerName $drServerName  `
   -FailoverGroupName $failoverGroupName `
   -FailoverPolicy Automatic `
   -GracePeriodWithDataLossHours 2
$failovergroup

# Add the database to the failover group
Write-host "Adding the database to the failover group..." 
Get-AzSqlDatabase `
   -ResourceGroupName $resourceGroupName `
   -ServerName $serverName `
   -DatabaseName $databaseName | `
Add-AzSqlDatabaseToFailoverGroup `
   -ResourceGroupName $resourceGroupName `
   -ServerName $serverName `
   -FailoverGroupName $failoverGroupName
Write-host "Successfully added the database to the failover group..." 

# Check role of secondary replica
Write-host "Confirming the secondary replica is secondary...." 
(Get-AzSqlDatabaseFailoverGroup `
   -FailoverGroupName $failoverGroupName `
   -ResourceGroupName $resourceGroupName `
   -ServerName $drServerName).ReplicationRole

# Failover to secondary server
Write-host "Failing over failover group to the secondary..." 
Switch-AzSqlDatabaseFailoverGroup `
   -ResourceGroupName $resourceGroupName `
   -ServerName $drServerName `
   -FailoverGroupName $failoverGroupName
Write-host "Failed failover group successfully to" $drServerName 



# Revert failover to primary server
Write-host "Failing over failover group to the primary...." 
Switch-AzSqlDatabaseFailoverGroup `
   -ResourceGroupName $resourceGroupName `
   -ServerName $serverName `
   -FailoverGroupName $failoverGroupName
Write-host "Failed failover group successfully back to" $serverName


# Show randomized variables
Write-host "Resource group name is" $resourceGroupName 
Write-host "Password is" $password  
Write-host "Server name is" $serverName 
Write-host "DR Server name is" $drServerName 
Write-host "Failover group name is" $failoverGroupName

# Clean up resources by removing the resource group
# Write-host "Removing resource group..."
# Remove-AzResourceGroup -ResourceGroupName $resourceGroupName
# Write-host "Resource group removed =" $resourceGroupName

此脚本使用以下命令。 表中的每条命令均链接到特定于命令的文档。Each command in the table links to command specific documentation.

#!/bin/bash
location="China East 2"
randomIdentifier=random123

resource="resource-$randomIdentifier"
server="sqlserver-$randomIdentifier"
database="database-$randomIdentifier"

failover="failover-$randomIdentifier"
failoverLocation="China North 2"
failoverServer="sqlsecondary-$randomIdentifier"

login="sampleLogin"
password="samplePassword123!"

echo "Using resource group $resource with login: $login, password: $password..."

echo "Creating $resource..."
az group create --name $resource --location "$location"

echo "Creating $server in $location..."
az sql server create --name $server --resource-group $resource --location "$location"  --admin-user $login --admin-password $password

echo "Creating $database on $server..."
az sql db create --name $database --resource-group $resource --server $server --sample-name AdventureWorksLT

echo "Creating $failoverServer in $failoverLocation..."
az sql server create --name $failoverServer --resource-group $resource --location "$failoverLocation" --admin-user $login --admin-password $password

echo "Creating $failover between $server and $failoverServer..."
az sql failover-group create --name $failover --partner-server $failoverServer --resource-group $resource --server $server --failover-policy Automatic --grace-period 2 --add-db $database

echo "Confirming role of $failoverServer is secondary..." # note ReplicationRole property
az sql failover-group show --name $failover --resource-group $resource --server $server

echo "Failing over to $failoverServer..."
az sql failover-group set-primary --name $failover --resource-group $resource --server $failoverServer 

echo "Confirming role of $failoverServer is now primary..." # note ReplicationRole property
az sql failover-group show --name $failover --resource-group $resource --server $server

echo "Failing back to $server...."
az sql failover-group set-primary --name $failover --resource-group $resource --server $server

此脚本使用以下命令。This script uses the following commands. 表中的每条命令均链接到特定于命令的文档。Each command in the table links to command specific documentation.

没有适用于 Azure 门户的脚本。There are no scripts available for the Azure portal.