你当前正在访问 Microsoft Azure Global Edition 技术文档网站。如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站，请访问 https://docs.azure.cn。

New-AzSqlDatabaseSecondary

参考

模块:: Az.Sql

为现有数据库创建辅助数据库，并开始数据复制。

语法

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>]

说明

New-AzSqlDatabaseSecondary cmdlet 在用于为数据库设置异地副本 (replica)时替换 Start-AzSqlDatabaseCopy cmdlet。它返回从主数据库到辅助数据库的异地副本 (replica)tion 链接对象。

示例

示例 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 数据库的读取意向。此参数的可接受值为：

否
全部

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 数据库的联合客户端 ID。它用于跨租户 CMK 方案。

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

-HighAvailabilityReplicaCount

与可路由只读应用程序意向连接的数据库关联的只读辅助副本 (replica)数。此属性仅适用于超大规模版本数据库。

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 数据库辅助数据库的计算生成。

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 数据库辅助数据库的 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 数据库副本 (replica)tion 链接关联的键值对。例如：@{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 数据库关联的区域冗余。此属性仅适用于超大规模版本数据库。

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

输入

String

输出

AzureReplicationLinkModel