我尝试根据本文将辅助数据库加入我的SQL Server 2012可用性组:

当我尝试执行此操作时,本地SQL Server Windows事件日志显示错误1407:

The remote copy of database "<DBNAME>" is not related to the local copy of the database

我已按照所有步骤操作,并使用NORECOVERY创建了最近的备份和还原。

目标SQL Server的错误日志给出以下错误:

AlwaysOn: The local replica of availability group '<AGNAME>' is going offline because the corresponding resource in the Windows Server Failover Clustering (WSFC) cluster is no longer online. This is an informational message only. No user action is required.

The state of the local availability replica in availability group '<AGNAME>' has changed from 'SECONDARY_NORMAL' to 'RESOLVING_NORMAL'. The replica state changed because of either a startup, a failover, a communication issue, or a cluster error. For more information, see the availability group dashboard, SQL Server error log, Windows Server Failover Cluster management console or Windows Server Failover Cluster log. 

The state of the local availability replica in availability group '<AGNAME>' has changed from 'RESOLVING_NORMAL' to 'NOT_AVAILABLE'. The replica state changed because of either a startup, a failover, a communication issue, or a cluster error. For more information, see the availability group dashboard, SQL Server error log, Windows Server Failover Cluster management console or Windows Server Failover Cluster log. 

群集及其所有节点均处于联机状态。 AG仪表板不提供任何其他信息来帮助诊断问题。

打开所有防火墙都不能解决问题。

Windows事件日志显示以下行:

The database 'DelphiOBUDB' is marked RESTORING and is in a state that does not allow recovery to be run.

但是,当您还原数据库并按照教程指南指定NORECOVERY标志时,该数据库将处于还原模式。

如何将数据库加入可用性组?