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 ·
Show more comments

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.