Share via

get error for distributed availability group Msg 35250, Level 16, State 7, Line 1 The connection to the primary replica is not active. The command cannot be processed

Yilma jima 5 Reputation points
2023-09-26T01:35:31.2466667+00:00

I performed a full backup and a transaction log backup from the global primary, and restore them to the forwarder with NORECOVERY option. But when run the following on the forwarder:

Script
ALTER DATABASE [db1] SET HADR AVAILABILITY GROUP = [distributedag]
error message :

Msg 35250, Level 16, State 7, Line 1

The connection to the primary replica is not active. The command cannot be processed

I use the same domain account for all nodes. it has administrator access on window server and in SQL server

SQL Server Other
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-09-26T05:36:12.5+00:00

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.