Configure availability group read-only routing, listener connections, replica URLs, balanced lists, and verification after failover.
SQL SERVER – Availability Groups Can Propagate Database Compatibility Level
Propagation of Compatibility Level needs verification on the actual availability-group topology. I compare each replica through its own connection.
What is Transactional Replication Supported Version Matrix? – Interview Question of the Week #274
Question: What is the Transactional Replication Supported Version Matrix?
The rules for the supported versions are pretty simple and clearly written.
Error 35296: Log Backup on Secondary Replica Fails in a Distributed Availability Group
Log backup on secondary replica fails with error 35296 when the replica sits in the secondary availability group of a distributed availability group. A client hit it on the fourth node of their topology. It is by design, so the backup has to run on a replica that talks to the global primary.
What is Source_Database_ID in Sys.Databases?- Interview Question of the Week #232
Question: What is Source_Database_ID in Sys.Databases and why it is mostly NULL? Very interesting question, I received indeed.
Transient Error in Automatic Seeding: Availability Database Failed to Seed
A transient error stopped automatic seeding of an availability database. The ERRORLOG on the secondary showed Msg 4353 about conflicting file relocations. Renaming a logical file let the database seed.
Availability Group Restore Error When You Add a Database
The availability group restore error appears when automatic seeding and a manual restore both fill the same secondary. The post explains the cause, shows read-only checks for the seeding mode and the replica roles, and gives the fix with its undo.