HADR_DATABASE_WAIT_FOR_TRANSITION_TO_VERSIONING

Question

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.

ronen_ariely · Answer

Hi&nbsp;yogii&nbsp;
&nbsp;
Please check the following article for more information and workaround:
https://techcommunity.microsoft.com/t5/core-infrastructure-and-security/alwayson-availability-groups-wait-type-hadr-database-wait-for/ba-p/371476?WT.mc_id=DP-MVP-5001699

Forum Discussion

HADR_DATABASE_WAIT_FOR_TRANSITION_TO_VERSIONING

Resources