Mid SQL

Synchronous Replication:?

  • Data is written to both the primary and secondary database simultaneously.
  • Advantages: Ensures data consistency between all replicas.
  • Disadvantages: May incur performance overhead due to the need to wait for

replication.

More from SQL Server Tutorial

All questions for this course