A COPY_ONLY full backup of the same database can have a different size on the primary and the secondary replica of an Always On group. This post reads the log pages in the backup messages, shows them on a standalone database and explains how to compare backups fairly. It also covers what a restore needs.
SQL SERVER – Automatic Seeding of Availability Database ‘DB’ in Availability Group ‘AG’ Failed With an Unrecoverable Error
Automatic seeding of availability database failed with an unrecoverable error: it showed on the secondary, then vanished. Here is what ERRORLOG said.
Automatic Seeding in Always On: List and Monitor It
Automatic seeding in Always On lets the primary send a database to a secondary without a manual backup and restore. Three read-only queries show which replicas use it, what happened before and how far a seeding run has come. It also covers why it fails and when to switch it off.
SQL SERVER – Drop failed for Availability Group – Failed to Destroy the Windows Server Failover Clustering Group Corresponding to Availability Group
While recovering a cluster in ForceQuorum mode, dropping an availability group failed: Failed to destroy the WSFC group. Here is how I got past this error.
SQL SERVER – Read Only Routing Error: Client Unable to Establish Connection Because an Error was Encountered During Handshakes Before Login
A client’s Always On read-only routing failed with: an error was encountered during handshakes before login. Here are the checks I shared and how we fixed it.
SQL SERVER – FIX: The specified instance of SQL Server is hosted by a system that is not a Windows Server Failover Cluster(WSFC) Node.
After a cluster rebuild, adding a replica failed: The specified instance is hosted by a system that is not a Windows Server Failover Cluster node. Here is the fix.
SQL SERVER – Availability Group Seen in SSMS but missing in Cluster Manager. What’s Wrong?
A client’s availability group showed in SSMS, but no role appeared in Failover Cluster Manager. Here is the sequence of steps that causes this and what to do.