• 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…


  • Database Crash Recovery Takes Forever After Planned Manual Failover

    Weekend Patching, Business As Usual Today I was patching a bunch of servers at a client as Microsoft released their most recent Security Patch for SQL Server that addresses an exploit / vulnerability found after patch Tuesday. Read more on it here. I went through the normal patching routine for an AG; working through all…