Blog Archives

Alwayson Availability Group Replica is Not Synchronizing (Error: 976, Severity: 14, State: 1.)

For some reason you can lose communication between the primary and secondary replicas. As known, there is a policy on SQL Server to check the data synchronization state of the database replica. The policy is in an unhealthy state when the

Tagged with: , ,
Posted in AlwaysOn, High Availability, Issues

Introducing Cloud Witness – [SQL Server]

We know that when we create a Cluster environment between two sites, we must take care about Quorum Witness. If you need automatic failover SLA in your company, the best way is to separate the (Quorum) FileShare Quitness at a

Tagged with: ,
Posted in Cluster, High Availability

How to validate Quorum Vote from Windows server Failover Cluster (AlwaysOn)

If you have configured a Windows server Failover Cluster with more than two Nodes, you must care about the “votes” in each Node. Let’s imagine the following environment: You have two Nodes configured in Automatic Failover/Synchronous mode with AlwaysOn Availability

Tagged with: , , ,
Posted in Administration, AlwaysOn, Cluster, High Availability

High Availability and Disaster Recover – Syncronize logins [SQL Server]

Often I connect in new environments and I see solutions of High Availability and Disaster Recovery. But just the simple solution is sufficient for your applications? I’m saying that because in many cases a just simple detail is forgotten. Many

Tagged with:
Posted in High Availability, Scripts, SQL Server Tips

Availability Groups Setup and Configuration from A to Z

AlwaysOn Availability Groups was introduced in SQL Server 2012, and it’s one of the most important features in the history of SQL Server. The link provided below, as far as I’m concerned, it’s a complete step by step on how

Tagged with: , ,
Posted in Administration, AlwaysOn, High Availability