SQL Server Alwayson diagnostics log is a useful tool to troubleshoot SQL Server Alwayson related issue. It saves the result of stored procedure system stored procedure sp_server_diagnostics… Read more “Realcase:SQL Server Alwayson diagnostics log is not created.”
Category: Alwayson Availability group
Create a hybrid Distributed Availability group Between SQL Windows and SQL Linux
This article describes how to create a SQL Server Distributed Availability Group (AG) for high availability on RHEL 7.6 and SQL Windows 2016. Here is the topology… Read more “Create a hybrid Distributed Availability group Between SQL Windows and SQL Linux”
Different AG groups have the exactly same group_id value if the group names are same and the ‘CLUSTER_TYPE = EXTERNAL/NONE’
For external/none cluster type, since there is no orchestration, each replica needs to know how to independently determine the AG ID, thus the AG group name is… Read more “Different AG groups have the exactly same group_id value if the group names are same and the ‘CLUSTER_TYPE = EXTERNAL/NONE’”
Password is required when adding a database to AG group if the database has a master key
When you are trying add a database having a ‘master key’ to a AG group, you will see the message in SSMS. You can’t move to next… Read more “Password is required when adding a database to AG group if the database has a master key”
SQL Server 