Creating Availability Group the Databases on the Secondary are Stuck in Restoring State?

Hi there,

After creating the availability group the databases on the Secondary are in a 'Restoring' state and the availability group dashboard displays 'This secondary replica is not connected to the primary replica. The connected state is DISCONNECTED.' How to join a secondary replica to an availability group?

TIA

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

bernsteingreg commented · Sep 16, 2019 at 08:12 PM

If I'm not mistaken, you are having trouble just getting this set up, correct? AlwaysOn was not previously working with this group correct?

It sounds like it may be the way you chose to set up AlwaysOn. Perhaps you chose the setting "Skip initial data synchronization" or "Automatic seeding"?

This article might help: https://blog.sqlauthority.com/2018/03/26/sql-server-alwayson-automatic-seeding-database-stuck-in-restoring-state/

0 ·

David 2 1 bernsteingreg commented · Sep 24, 2019 at 03:10 PM

Thanks for your suggestion. I managed to resolve the issue. The problem was that the SQL Server service needs to run under the same domain user account on both primary and secondary for the synchronization to work. When it does the secondary database changes state from restoring. The following link resolved the problem:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/555c18b0-ae44-4c2e-bc2c-234392c7dec0/alwayon-problems-creating-alwayson-availability-group?forum=sqldisasterrecovery

0 ·