HADR_DATABASE_WAIT_FOR_TRANSITION_TO_VERSIONING

[yogii]

While querying AG secondary DB we are seeing the wait type HADR_DATABASE_WAIT_FOR_TRANSITION_TO_VERSIONING and couldn't run any queries. Does anyone know the workaround to access the database while seeing this wait type? don't see working solutions online.

[#2]

Hi @yogii 

Please check the following article for more information and workaround:

https://techcommunity.microsoft.com/t5/core-infrastructure-and-security/alwayson-availability-groups...