Unable to join db to always on high availability group

• Terence Keys

  Ten Centuries

  Points: 1140

  More actions

  June 12, 2023 at 1:11 pm

  #4209553

  Hi

  I am trying to join a database on a secondary high-availability instance. I did a no-recovery restore of the DB and the log but the moment I join the DB to the availability group it fails and sets itself to single-user mode and is basically not accessible after that. I can't figure out where I'm going wrong. Any ideas?

  • This topic was modified 1 year, 6 months ago by  Terence Keys.

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  June 13, 2023 at 7:48 am

  #4210074

  How are you doing the addition?  Via the GUI?

  Could you script it instead using various ALTER AVAILABILITY GROUP commands to do the same and see if it's a GUI vs T-SQL issue?

• June 13, 2023 at 8:36 am

  This was removed by the editor as SPAM