question

David 2 1 avatar image
David 2 1 asked

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

clusteralways-onavailability-groups
2 comments
10 |1200 characters needed characters left characters exceeded

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

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 Likes 0 ·

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 Likes 0 ·

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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