New-AzSqlDatabaseSecondary

參考

模組:: Az.Sql

針對現有資料庫建立次要資料庫並開始資料複寫。

Syntax

New-AzSqlDatabaseSecondary
   [-DatabaseName] <String>
   [-SecondaryServiceObjectiveName <String>]
   [-SecondaryElasticPoolName <String>]
   [-Tags <Hashtable>]
   -PartnerResourceGroupName <String>
   -PartnerServerName <String>
   [-PartnerDatabaseName <String>]
   [-AllowConnections <AllowConnections>]
   [-AsJob]
   [-LicenseType <String>]
   [-BackupStorageRedundancy <String>]
   [-SecondaryType <String>]
   [-HighAvailabilityReplicaCount <Int32>]
   [-ZoneRedundant]
   [-AssignIdentity]
   [-EncryptionProtector <String>]
   [-UserAssignedIdentityId <String[]>]
   [-KeyList <String[]>]
   [-FederatedClientId <Guid>]
   [-EncryptionProtectorAutoRotation]
   [-ServerName] <String>
   [-ResourceGroupName] <String>
   [-DefaultProfile <IAzureContextContainer>]
   [-WhatIf]
   [-Confirm]
   [<CommonParameters>]

New-AzSqlDatabaseSecondary
   [-DatabaseName] <String>
   [-Tags <Hashtable>]
   -PartnerResourceGroupName <String>
   -PartnerServerName <String>
   [-PartnerDatabaseName <String>]
   [-AllowConnections <AllowConnections>]
   [-AsJob]
   -SecondaryComputeGeneration <String>
   -SecondaryVCore <Int32>
   [-SecondaryComputeModel <String>]
   [-LicenseType <String>]
   [-AutoPauseDelayInMinutes <Int32>]
   [-MinimumCapacity <Double>]
   [-BackupStorageRedundancy <String>]
   [-SecondaryType <String>]
   [-HighAvailabilityReplicaCount <Int32>]
   [-ZoneRedundant]
   [-AssignIdentity]
   [-EncryptionProtector <String>]
   [-UserAssignedIdentityId <String[]>]
   [-KeyList <String[]>]
   [-FederatedClientId <Guid>]
   [-EncryptionProtectorAutoRotation]
   [-ServerName] <String>
   [-ResourceGroupName] <String>
   [-DefaultProfile <IAzureContextContainer>]
   [-WhatIf]
   [-Confirm]
   [<CommonParameters>]

Description

New-AzSqlDatabaseSecondary Cmdlet 會在用於設定資料庫的異地複寫時，取代 Start-AzSqlDatabaseCopy Cmdlet。它會將異地復寫連結物件從主資料庫傳回至輔助資料庫。

範例

範例 1：建立主動式異地複寫

$database = Get-AzSqlDatabase -DatabaseName $databasename -ResourceGroupName $primaryresourcegroupname -ServerName $primaryservername
$database | New-AzSqlDatabaseSecondary -PartnerResourceGroupName $secondaryresourcegroupname -PartnerServerName $secondaryservername -AllowConnections "All"

範例 2：建立主動式異地複寫，並指定要與源資料庫名稱不同的夥伴資料庫名稱

$database = Get-AzSqlDatabase -DatabaseName $databasename -ResourceGroupName $primaryresourcegroupname -ServerName $primaryservername
$database | New-AzSqlDatabaseSecondary -PartnerResourceGroupName $secondaryresourcegroupname -PartnerServerName $secondaryservername -PartnerDatabaseName $secondarydatabasename -AllowConnections "All"

參數

-AllowConnections

指定次要 Azure SQL 資料庫的讀取意圖。此參數可接受的值為：

No
全部

Type:	AllowConnections
Accepted values:	No, All
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-AsJob

在背景執行 Cmdlet

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

-AssignIdentity

產生並指派此資料庫的 Microsoft Entra 身分識別，以便與 Azure KeyVault 等密鑰管理服務搭配使用。

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

-AutoPauseDelayInMinutes

資料庫自動暫停延遲分鐘（僅限無伺服器），-1 退出宣告

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

-BackupStorageRedundancy

用來儲存 SQL 資料庫備份的備份記憶體備援。選項包括：本機、區域和地理位置。

Type:	String
Accepted values:	Local, Zone, Geo, GeoZone
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:	False
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-DatabaseName

指定要做為主要資料庫的資料庫名稱。

Type:	String
Position:	2
Default value:	None
Required:	True
Accept pipeline input:	True
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

-EncryptionProtector

SQL 資料庫複製的加密保護裝置金鑰。

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

-EncryptionProtectorAutoRotation

AKV 金鑰自動輪替狀態

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

-FederatedClientId

SQL 資料庫的同盟用戶端標識碼。它用於跨租使用者 CMK 案例。

Type:	Nullable<T>[Guid]
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-HighAvailabilityReplicaCount

與可路由傳送只讀應用程式意圖連接之資料庫的唯讀次要複本數目。此屬性僅適用於超大規模資料庫。

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

-KeyList

SQL 資料庫複本的 AKV 金鑰清單。

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

-LicenseType

Azure Sql 資料庫的授權類型。

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

-MinimumCapacity

如果尚未暫停，輔助資料庫一律會配置的最小容量。僅適用於無伺服器 Azure Sql 資料庫。

Type:	Double
Aliases:	MinVCore, MinCapacity
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-PartnerDatabaseName

要建立的輔助資料庫名稱。

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

-PartnerResourceGroupName

指定此 Cmdlet 指派輔助資料庫之 Azure 資源群組的名稱。

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

-PartnerServerName

指定要作為次要的 Azure SQL 資料庫伺服器名稱。

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

-ResourceGroupName

指定此 Cmdlet 指派主資料庫的 Azure 資源群組名稱。

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

-SecondaryComputeGeneration

Azure Sql Database 次要資料庫的計算產生。

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

-SecondaryComputeModel

Azure Sql 資料庫輔助資料庫的計算模型。無伺服器或已布建

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

-SecondaryElasticPoolName

指定要在其中放置輔助資料庫之彈性集區的名稱。

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

-SecondaryServiceObjectiveName

指定要指派給輔助資料庫的服務目標名稱。

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

-SecondaryType

如果資料庫是輔助資料庫，則為次要類型。有效值為 Geo 和 Named。

Type:	String
Accepted values:	Named, Geo, Standby
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SecondaryVCore

Azure Sql Database 次要的 Vcore 編號。

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

-ServerName

指定主要 SQL 資料庫的 SQL Server 名稱。

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

-Tags

指定哈希表形式的索引鍵/值組，以便與 SQL 資料庫複寫鏈接產生關聯。例如：@{key0=“value0”;key1=$null;key2=“value2”}

Type:	Hashtable
Aliases:	Tag
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-UserAssignedIdentityId

SQL 資料庫複本的使用者指派身分識別清單。

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:	False
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-ZoneRedundant

要與 Azure Sql Database 建立關聯的區域備援。此屬性僅適用於超大規模資料庫。

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

輸入

String

輸出

AzureReplicationLinkModel