When setting up an AlwaysOn Availability Group with a synchronous replica you may find that the secondary replica never becomes synchronized and you are presented with the following error “Data synchronization state of some availability database is not healthy”. Effectively the databases restore to the replicas, but synchronization does not start. The first thing to … Continue reading Troubleshooting AlwaysOn Availability Groups in SQL2012
Tag: always on
As you move your platform from running on a single database and single server to running on a highly available scenario, be that a Mirror, AlwaysOn, or a cloud based platform like Windows or SQL Azure, you will find out that highly available does not equal highly reliable! The service will still go down during … Continue reading Dealing with Failover and Transient Errors on a Mirror, Always On or Azure