Forum Discussion

MrMSSQL's avatar
MrMSSQL
Copper Contributor
Apr 24, 2024

16.0.4120.1 - 2 errors - sqlserve.exe does not try again to recover databases but waits forever

Hey   I have a 2 node HA/AO - with a fileshare witness. Cluster events tells me there were a disconnect and cluster error.   The group listeners is configured "auto/auto/sync", in the anticipati...
SivertSolem's avatar
SivertSolem
Iron Contributor
Apr 24, 2024

MrMSSQL 

If you have seeding issues, you could try to start the automatic seeding attempt again, as documented here. The same query is used both to start _and_ restart seeding.
https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/automatically-initialize-always-on-availability-group?view=sql-server-ver16#enable-automatic-seeding-on-an-existing-availability-group

 

ALTER AVAILABILITY GROUP [<availability_group_name>] 
    MODIFY REPLICA ON '<secondary_node>' 
    WITH (SEEDING_MODE = AUTOMATIC)
GO

 Note that the query is run on the current primary.

  • MrMSSQL's avatar
    MrMSSQL
    Copper Contributor
    Apr 26, 2024

    SivertSolem 

    Thanks for the reply, I will try the next time this happens.

Resources