SQL Server Always on availability group is a great addition to SQL Server for providing high availability and disaster recovery. Always-on availability group support failover the environment for a discrete set of user databases, known as availability databases, that failover together. They also support a set of read-write primary databases and several sets of corresponding secondary databases. Optionally, AGs can make secondary databases available for read-only access and some backup operations.  

SQL Server log shipping is another popular disaster recovery solution that utilizes transaction log backups shipped from a primary database on a primary SQL server instance to one or more secondary databases on separate secondary SQL server instances. The transaction log backups are applied to each secondary database individually to obtain a synchronized database as primary.

Leave a Reply

Your email address will not be published. Required fields are marked *