Availability-group DDL operations are permitted only when you are using the master database. Run the USE MASTER command, and retry your availability-group DDL command.

Question:

SQL SERVER  alwayson在向AG中添加DB最后一步在副本中将此DB添加入AG时报错：

Availability-group DDL operations are permitted only when you are using the master database.  Run the USE MASTER command, and retry your availability-group DDL command. (Microsoft SQL Server, Error: 35208)

 

Answer:

手动执行语句加入AG

use master;

alter database MBU_Report set hadr availability group = "CDS6CDS8AlwaysOn";