AlwaysOn high availability group, HAG, is easier to maintain than log shipping.

An AlwaysOn HAG gives you the flexibility of being able to fail over back and forth between your AlwaysOn replicas.

Now lets take a look at Log Shipping. Without doing a cut and paste from the Microsoft books online there are five steps that have to be manually performed before you can failover. 

SQL Server AlwaysOn

SQL Server AlwaysOn is a marketing term which refers to the high availability and disaster recovery solution introduced when SQL Server 2012 was launched.

Sources:

https://dba.stackexchange.com/questions/199064/log-shipping-or-always-on-as-dr-for-sql-failover-cluster

Last modified: July 28, 2020

Author

Comments

Write a Reply or Comment