Switch-AzSqlDatabaseInstanceFailoverGroup

Referensi

Modul:: Az.Sql

Menjalankan failover Grup Failover Instans.

Sintaks

Switch-AzSqlDatabaseInstanceFailoverGroup
      [-ResourceGroupName] <String>
      [-Location] <String>
      [-Name] <String>
      [-AllowDataLoss]
      [-DefaultProfile <IAzureContextContainer>]
      [-WhatIf]
      [-Confirm]
      [<CommonParameters>]

Switch-AzSqlDatabaseInstanceFailoverGroup
      [-Location] <String>
      [-ResourceId] <String>
      [-AllowDataLoss]
      [-DefaultProfile <IAzureContextContainer>]
      [-WhatIf]
      [-Confirm]
      [<CommonParameters>]

Switch-AzSqlDatabaseInstanceFailoverGroup
      [-InputObject] <AzureSqlInstanceFailoverGroupModel>
      [-AllowDataLoss]
      [-DefaultProfile <IAzureContextContainer>]
      [-WhatIf]
      [-Confirm]
      [<CommonParameters>]

Deskripsi

Perintah ini menukar peran instans terkelola dalam Grup Failover Instans dengan melakukan failover ke wilayah sekunder yang ditentukan, menjadikannya wilayah utama baru. Semua sesi TDS baru yang terhubung ke titik akhir utama secara otomatis dirutekan ulang ke wilayah utama baru.

Contoh

Contoh 1

Get-AzSqlDatabaseInstanceFailoverGroup -ResourceGroupName rg -Location location -Name fg | Switch-AzSqlDatabaseInstanceFailoverGroup -AllowDataLoss

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

Terbitkan operasi failover yang memungkinkan kehilangan data dengan melakukan piping di Grup Failover Instans.

Contoh 2

Get-AzSqlDatabaseInstanceFailoverGroup -ResourceGroupName rg -Location location -Name fg | Switch-AzSqlDatabaseInstanceFailoverGroup

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

Terbitkan operasi failover upaya terbaik yang akan berhasil tanpa kehilangan data atau gagal dan gulung balik.

Parameter

-AllowDataLoss

Selesaikan failover bahkan jika melakukannya dapat mengakibatkan kehilangan data. Ini akan memungkinkan failover untuk melanjutkan meskipun database utama tidak tersedia.

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

-Confirm

Meminta Anda mengonfirmasi sebelum menjalankan cmdlet.

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

-DefaultProfile

Kredensial, akun, penyewa, dan langganan yang digunakan untuk komunikasi dengan Azure.

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

-InputObject

Objek Grup Failover Instans untuk dialihkan

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

-Location

Nama Wilayah Lokal instans sekunder di Grup Failover Instans.

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

-Name

Nama Grup Failover Instans.

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

-ResourceGroupName

Nama grup sumber daya instans sekunder di Grup Failover Instans.

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

-ResourceId

ID Sumber Daya Grup Failover Instans untuk beralih.

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

-WhatIf

Menunjukkan apa yang akan terjadi jika cmdlet berjalan. Cmdlet tidak dijalankan.

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

Input

AzureSqlInstanceFailoverGroupModel

System.String

Output