New-AzSqlDatabaseInstanceFailoverGroup

參考

模組:: Az.Sql

此命令會建立新的 Azure SQL 資料庫實例故障轉移群組。

Syntax

New-AzSqlDatabaseInstanceFailoverGroup
   [-Name] <String>
   [-PartnerResourceGroupName <String>]
   -PartnerRegion <String>
   -PrimaryManagedInstanceName <String>
   -PartnerManagedInstanceName <String>
   [-PartnerSubscriptionId <String>]
   [-FailoverPolicy <String>]
   [-GracePeriodWithDataLossHours <Int32>]
   [-AllowReadOnlyFailoverToPrimary <String>]
   [-SecondaryType <String>]
   [-ResourceGroupName] <String>
   [-Location] <String>
   [-DefaultProfile <IAzureContextContainer>]
   [-WhatIf]
   [-Confirm]
   [<CommonParameters>]

Description

使用指定的受控執行個體組，在指定的區域之間建立新的 Azure SQL 資料庫實例故障轉移群組。

兩個 Azure SQL 資料庫 TDS 端點會在 Name.SqlDatabaseDnsSuffix （例如，Name.database.windows.net）和 Name.secondary.SqlDatabaseDnsSuffix 上建立。這些端點可用來分別連線到故障轉移群組的主要和次要區域。如果主要區域受到中斷的影響，則會依照實例故障轉移群組的故障轉移原則和寬限期來觸發端點和資料庫的自動故障轉移。

在實例故障轉移群組功能的預覽期間，『-GracePeriodWithDataLossHours』參數僅支援大於或等於 1 小時的值。

範例

範例 1

$failoverGroup = New-AzSqlDatabaseInstanceFailoverGroup -Name fgName -Location location -ResourceGroupName rg -PrimaryManagedInstanceName $managedInstance.Name -PartnerRegion $partnerRegion -PartnerManagedInstanceName $partnerManagedInstance.Name -FailoverPolicy Automatic -GracePeriodWithDataLossHours 1

ResourceGroupName                     : rg
Location                              : East US
Name                                  : fg
PartnerResourceGroupName              : rg
PartnerRegion                         : West US
PrimaryManagedInstanceName            : managedInstance1
PartnerManagedInstanceName            : managedInstance2
ReplicationRole                       : Primary
ReplicationState                      : CATCH_UP
ReadWriteFailoverPolicy               : Automatic
FailoverWithDataLossGracePeriodHours  : 1
ReadOnlyFailoverPolicy                : Disabled
Id                                    : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/rg/providers/Microsoft.Sql/locations/eastus/instanceFailoverGroups/fg

此命令會為受控執行個體組建立具有故障轉移原則『Automatic』的新實例故障轉移群組。

範例 2

$failoverGroup = New-AzSqlDatabaseInstanceFailoverGroup -Name fgName -Location location -ResourceGroupName rg -PrimaryManagedInstanceName $managedInstance.Name -PartnerRegion $partnerRegion -PartnerManagedInstanceName $partnerManagedInstance.Name -FailoverPolicy Manual

ResourceGroupName                     : rg
Location                              : East US
Name                                  : fg
PartnerResourceGroupName              : rg
PartnerRegion                         : West US
PrimaryManagedInstanceName            : managedInstance1
PartnerManagedInstanceName            : managedInstance2
ReplicationRole                       : Primary
ReplicationState                      : CATCH_UP
ReadWriteFailoverPolicy               : Manual
FailoverWithDataLossGracePeriodHours  :
ReadOnlyFailoverPolicy                : Disabled
Id                                    : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/rg/providers/Microsoft.Sql/locations/eastus/instanceFailoverGroups/fg

此命令會為受控執行個體組建立具有故障轉移原則『Manual』的新實例故障轉移群組。

範例 3

此命令會建立新的 Azure SQL 資料庫實例故障轉移群組。（自動產生）

New-AzSqlDatabaseInstanceFailoverGroup -FailoverPolicy Automatic -GracePeriodWithDataLossHours 1 -Location location -Name fgName -PartnerManagedInstanceName $partnerManagedInstance.Name -PartnerRegion $partnerRegion -PartnerResourceGroupName rg2 -PrimaryManagedInstanceName $managedInstance.Name -ResourceGroupName rg

參數

-AllowReadOnlyFailoverToPrimary

輔助伺服器上的中斷是否應該觸發只讀端點的自動故障轉移。

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Confirm

執行 Cmdlet 之前先提示您確認。

Type:	SwitchParameter
Aliases:	cf
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-DefaultProfile

用於與 Azure 通訊的認證、帳戶、租用戶和訂用帳戶。

Type:	IAzureContextContainer
Aliases:	AzContext, AzureRmContext, AzureCredential
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-FailoverPolicy

實例故障轉移群組的故障轉移原則。

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-GracePeriodWithDataLossHours

如果主伺服器上發生中斷且無法完成故障轉移，且數據遺失，則起始自動故障轉移之前的間隔。

Type:	Int32
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Location

要從中擷取實例故障轉移群組的本機區域名稱。

Type:	String
Position:	1
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-Name

要建立的 Azure SQL 資料庫故障轉移群組名稱。

Type:	String
Position:	2
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-PartnerManagedInstanceName

要新增至實例故障轉移群組之夥伴區域中受控執行個體的名稱。

Type:	String
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-PartnerRegion

實例故障轉移群組之夥伴區域的名稱。

Type:	String
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-PartnerResourceGroupName

實例故障轉移群組的次要資源群組名稱。

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-PartnerSubscriptionId

實例故障轉移群組之次要受控執行個體的訂用帳戶標識碼。只有跨訂用帳戶設定才需要此參數

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-PrimaryManagedInstanceName

要新增至實例故障轉移群組之本機區域中受控執行個體的名稱。

Type:	String
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-ResourceGroupName

資源群組的名稱。

Type:	String
Position:	0
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-SecondaryType

次要實例的預期用法。待命表示次要實例將作為被動復本，僅供災害復原使用。

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-WhatIf

顯示執行 Cmdlet 後會發生的情況。未執行 Cmdlet。

Type:	SwitchParameter
Aliases:	wi
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

輸入

String

輸出

AzureSqlInstanceFailoverGroupModel