DBA Unfiltered

  • Mechanical robotic mule carrying multiple servers and data storage units on a mountain path

    Contained AG Not Synchronizing After Planned Failover: How ADR Saved Us

    We had a SQL Server 2022 contained AG that consistently took exactly 10 minutes to recover after every planned manual failover. Not 9 minutes. Not 11. 10 minutes on the dot. Both replicas would sit in a Not Synchronizing state, every database showed Recovering, and our fastest path back to being online again was often…

    TheUnfilteredDBA