Can a database be added to an HA group online?


I created a new database on my HA server and I need to add it the to availability group. It's a new database and doesn't have anything in it. The HA group contains multiple critical databases running in it.

Can I add the new database to the HA group without affecting the currently running databases? Will it bring down the HA during the operation?

Didn't find that info on msdn. Thanks for the help

1 answer

  • answered 2021-01-12 19:27 Ben Thul

    You can add a new database to an existing availability group without impact to the AG and little impact to the affected database. I'm not saying "no impact to the database" because as soon as you add the database to the AG, the rules of clearing the transaction log for databases in an AG apply. Which means that you'll need to have a plan to get any secondary replicas in sync with the primary ASAP.