CODEWITHSUNDEEP
sql-serverazure
askmesession
askmesession

Reputation: 40

Microsoft Azure - sql server replication vs availability groups

What are the main differences between sql-server replication and availability groups in an Azure Iaas data solution? (sql server instances on a VM) Are these the same concept?

Upvotes: 1

Views: 1013

Answers (1)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 89051

SQL Server Replication copies data and replays changes using SQL Commands to replicas. Sometimes this is called "Logical Replication". Replication is typically not used for High-Availability or Disaster Recovery, but can be used to create a readable replica of a production database or to copy selected data from a main database into one or more subscribers.

AlwaysOn Availability Groups copies and applies the log records to syncronize databases. The changes are applied using the same transaction log redo process that's used in backup/restore and database recovery. Sometimes this is called "Physical Replication", as the database files on every replica are identical. AlwaysOn Availability Groups can be used for High-Availability, Disaster Recovery, and to create Readable Replicas of a production database.

Upvotes: 2

Related Questions