Tags » AlwaysOn

AlwaysOn : Better Together - Using AlwaysOn Availability Group and Log Shipping

In recent past once of my friend came with a requirement where she wanted to use log shipping along with AlwaysOn Availability Group. I asked “are you not happy with 4 secondary replicas in SQL 2012 and 8 secondary replicas in SQL 2014? 300 more words


Solution : The connection to the primary replica is not active. The command cannot be processed.

It has been close to a year since I published my first book (SQL Server 2012 AlwaysOnPaperback, Kindle) and since then I have been contacted by many DBA to troubleshoot various issue related to AlwaysOn Availability Groups. 668 more words

Sql Server

Simple AlwaysOn Availability Group databases' logs maintenance

AlwaysOn Availability Group brought new High Availability solutions with small to no impact on applications being the SQL Server Name clustered and therefor solving the fallback connection string required to support database Mirroring. 306 more words

Microsoft SQL Server 2012