SQL 2017 SQLPS执行Add-SqlAvailabilityDatabase异常

wuliws

调Ì¡Â试º?: (Add-SqlAvailabilityDatabase) In method Proce***ecord. Resolving targets.　　
调Ì¡Â试º?: (Add-SqlAvailabilityDatabase) Resolving targets: Parameter Set = 'ByObject'
　　
调Ì¡Â试º?: (Add-SqlAvailabilityDatabase) Resolved target [App1On]
　　
调Ì¡Â试º?: (Add-SqlAvailabilityDatabase) GetShouldProcessTargetString in SqlCmdlet.
　　
调Ì¡Â试º?: (Add-SqlAvailabilityDatabase) Validating Target
　　
调Ì¡Â试º?: (Add-SqlAvailabilityDatabase) ValidateTarget in SqlCmdlet. Returning true.
　　
调Ì¡Â试º?: (Add-SqlAvailabilityDatabase) Target is valid. Calling BeginTargetProcessing.
　　
调Ì¡Â试º?: (Add-SqlAvailabilityDatabase) In BeginTargetProcessing
　　
调Ì¡Â试º?: (Add-SqlAvailabilityDatabase) Subscribing to server events: InfoMesage, StatementExecuted
　　
调Ì¡Â试º?: (Add-SqlAvailabilityDatabase) Done with BeginTargetProcessing. Calling ProcessTarget.
　　
详¨º细?信?息¡é:
　　
select * into #tmpag_availability_groups from master.sys.availability_groups
　　
select agstates.group_id, agstates.primary_replica into #tmpag_availability_group_states from ma
　　
ster.sys.dm_hadr_availability_group_states as agstates
　　
select group_id, replica_id, replica_metadata_id into #tmpag_availability_replicas from master.s
　　
ys.availability_replicas
　　
select replica_id, is_local, role into #tmpag_availability_replica_states from master.sys.dm_had
　　
r_availability_replica_states
　　
SELECT
　　
AG.name AS [Name],
　　
AG.group_id AS [UniqueId],
　　
ISNULL(AG.automated_backup_preference, 4) AS [AutomatedBackupPreference],
　　
ISNULL(AG.failure_condition_level, 6) AS [FailureConditionLevel],
　　
ISNULL(AG.health_check_timeout, -1) AS [HealthCheckTimeout],
　　
ISNULL(agstates.primary_replica, '') AS [PrimaryReplicaServerName],
　　
ISNULL(arstates2.role, 3) AS [LocalReplicaRole],
　　
AR2.replica_metadata_id AS [ID],
　　
ISNULL(AG.basic_features, 0) AS [BasicAvailabilityGroup],
　　
ISNULL(AG.db_failover, 0) AS [DatabaseHealthTrigger],
　　
ISNULL(AG.dtc_support, 0) AS [DtcSupportEnabled],
　　
ISNULL(AG.is_distributed, 1) AS [IsDistributedAvailabilityGroup],
　　
ISNULL(AG.cluster_type, 0) AS [ClusterType],
　　
ISNULL(AG.required_copies_to_commit, 0) AS [RequiredCopiesToCommit]
　　
FROM
　　
#tmpag_availability_groups AS AG
　　
LEFT OUTER JOIN #tmpag_availability_group_states as agstates ON AG.group_id = agstates.group_id
　　
INNER JOIN #tmpag_availability_replicas AS AR2 ON AG.group_id = AR2.group_id
　　
INNER JOIN #tmpag_availability_replica_states AS arstates2 ON AR2.replica_id = arstates2.replica_id AN
　　
D arstates2.is_local = 1
　　
WHERE
　　
(AG.name=@_msparam_0)
　　
drop table #tmpag_availability_groups
　　
drop table #tmpag_availability_group_states
　　
drop table #tmpag_availability_replicas
　　
drop table #tmpag_availability_replica_states
　　
详¨º细?信?息¡é:
　　
drop table #tmpag_availability_groups
　　
drop table #tmpag_availability_group_states
　　
drop table #tmpag_availability_replicas
　　
drop table #tmpag_availability_replica_states
　　
调Ì¡Â试º?: (Add-SqlAvailabilityDatabase) Exception occurred Microsoft.SqlServer.Management.Common.ExecutionFa
　　
ilureException: 执¡ä行D Transact-SQL 语®?句?或¨°批¨²处ä|理¤¨ª时º¡À发¤¡é生¦¨²了¢?异°¨¬常¡ê。¡ê ---> System.Data.SqlClient.SqlException: 列¢D名? 'required_co
　　
pies_to_commit' 无T效¡ì。¡ê
　　
在¨² Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Obj
　　
ect execObject, DataSet fillDataSet, Boolean catchException)
　　
在¨² Microsoft.SqlServer.Management.Common.ServerConnection.GetExecuteReader(SqlCommand command)
　　
--- 内¨²部?异°¨¬常¡ê堆?栈?跟¨²踪Á¨´的Ì?结¨¢尾2 ---
　　
在¨² Microsoft.SqlServer.Management.Common.ServerConnection.GetExecuteReader(SqlCommand command)
　　
在¨² Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataReader(String query, SqlCommand& command)
　　
在¨² Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(ExecuteSql execSql, String
　　
query)
　　
在¨² Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con,
　　
StatementBuilder sb, RetriveMode rm)
　　
在¨² Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection
　　
sql, Object connectionInfo, StatementBuilder sb)
　　
在¨² Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult,
　　
ResultType resultType)
　　
在¨² Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result)
　　
在¨² Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData()
　　
在¨² Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData(Request req, Object ci)
　　
在¨² Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetData(Object connectionInfo, Request request)
　　
在¨² Microsoft.SqlServer.Management.Smo.ExecutionManager.GetEnumeratorDataReader(Request req)
　　
在¨² Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetInitDataReader(String[] fields, OrderBy[] orde
　　
rby)
　　
在¨² Microsoft.SqlServer.Management.Smo.SqlSmoObject.ImplInitialize(String[] fields, OrderBy[] orderby
　　
)
　　
在¨² Microsoft.SqlServer.Management.Smo.SqlSmoObject.Initialize(Boolean allProperties)
　　
在¨² Microsoft.SqlServer.Management.Smo.SqlSmoObject.OnPropertyMissing(String propname, Boolean useDef
　　
aultValue)
　　
在¨² Microsoft.SqlServer.Management.Smo.PropertyCollection.RetrieveProperty(Int32 index, Boolean useDe
　　
faultOnMissingValue)
　　
在¨² Microsoft.SqlServer.Management.Smo.PropertyCollection.GetValueWithNullReplacement(String property
　　
Name, Boolean throwOnNullValue, Boolean useDefaultOnMissingValue)
　　
在¨² Microsoft.SqlServer.Management.Smo.AvailabilityGroup.get_PrimaryReplicaServerName()
　　
在¨² Microsoft.SqlServer.Management.PowerShell.Hadr.CmdletUtilities.IsReplicaPrimary(AvailabilityGroup
　　
ag, SmoRecordContext context)
　　
在¨² Microsoft.SqlServer.Management.PowerShell.Hadr.AddSqlAvailabilityGroupDatabaseCommand.ProcessTarg
　　
et(AvailabilityGroup target, SmoRecordContext context)
　　
在¨² Microsoft.SqlServer.Management.PowerShell.SqlCmdlet`1.Proce***ecord()
　　
调Ì¡Â试º?: (Add-SqlAvailabilityDatabase) Calling EndProcessing.
　　
调Ì¡Â试º?: (Add-SqlAvailabilityDatabase) In EndTargetProcessing
　　
调Ì¡Â试º?: (Add-SqlAvailabilityDatabase) Unsubscribing from server events: InfoMesage, StatementExecuted
　　
Add-SqlAvailabilityDatabase : 执¡ä行D Transact-SQL 语®?句?或¨°批¨²处ä|理¤¨ª时º¡À发¤¡é生¦¨²了¢?异°¨¬常¡ê。¡ê
　　
所¨´在¨²位?置? 行D:1 字Á?符¤?: 1
　　
+ Add-SqlAvailabilityDatabase -InputObject $ag -Database $DatabaseList -Debug
　　
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
　　
+ CategoryInfo : NotSpecified: (:) [Add-SqlAvailabilityDatabase], ExecutionFailureExcep
　　
tion
　　
+ FullyQualifiedErrorId : Microsoft.SqlServer.Management.Common.ExecutionFailureException,Micros
　　
oft.SqlServer.Management.PowerShell.Hadr.AddSqlAvailabilityGroupDatabaseCommand