差异SQL复制/ SQL日志传送/ SQL数据库镜像和SQL可用性组 [英] Difference SQL Replication/SQL Log shipping/SQL Database Mirroring and SQL Availability Groups

问题描述

SQL复制/ SQL日志传送/ SQL数据库镜像之间的区别 和SQL可用性组

SQL镜像和Win故障转移群集的SQL AG组合？

选择这些技术的可能方案：

设置SQL AG后，是否需要SQL日志传送/ SQL数据库镜像？

 

解决方案

< blockquote>

数据库镜像是连续的logshipping，尽管您只能镜像到一个数据库。 SQL可用性组正在镜像，但您可以访问镜像到的数据库以进行只读访问。它位于Windows群集之上，您可以镜像到
多个数据库。因此SQL AG是SQL镜像和Windows故障转移群集的组合。使用SQL Ags，您共享一个名称（称为侦听器），但不共享存储。

设置SQL AG后，您不需要使用SQL日志传送，并且数据库受到保护SQL AG使用镜像，但您可以镜像不受SQL AG保护的数据库。

SQL Replication允许您将对一个或多个表的更改复制到一个或多个数据库。

Difference between SQL Replication/SQL Log shipping/SQL Database Mirroring  and SQL Availability Groups

Is SQL AG combination of SQL Mirroring and Win failover cluster?

Likely scenarios to choose these technologies :

Once SQL AG is set up, does SQL Log shipping/SQL Database Mirroring is required?

 

解决方案

Database mirroring is continuous logshipping although you can only mirror to one database. SQL Availability Groups is mirroring, but you can access the database you mirror to for read only access. It sits on top of windows clustering and you can mirror to more than one database. So SQL AG is a combination of SQL Mirroring and Windows Failover Clustering. With SQL Ags you share a name (called a listener), but do not share storage.

Once you setup a SQL AG you do not need to use SQL Log Shipping, and a database protected by a SQL AG uses mirroring, but you can mirror databases which are not protected by a SQL AG.

SQL Replication allows you to copy changes to one or more tables to one or more databases.

这篇关于差异SQL复制/ SQL日志传送/ SQL数据库镜像和SQL可用性组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！