sql server 面试_SQL Server复制面试问题与解答

sql server 面试

In this article, we will discuss a number of interview questions that cover the SQL Server Replication concept, components, types, and troubleshooting scenarios.

在本文中，我们将讨论许多采访问题，涉及SQL Server复制的概念，组件，类型和故障排除方案。

Preparing to attend an interview for a SQL Server Database Administrator position? Make sure that you are ready to answer multiple questions about the SQL Replication feature, which is considered as an example of the High Availability and Disaster Recovery solutions provided by Microsoft SQL Server.

准备参加SQL Server数据库管理员职位的面试吗？ 确保您准备好回答有关SQL复制功能的多个问题，这被视为Microsoft SQL Server提供的高可用性和灾难恢复解决方案的示例。

Q1: What is the SQL Server Replication feature?

Q1：什么是SQL Server复制功能？

SQL Server Replication is a data distribution technique that is used to copy and synchronize the database data and objects from one database to another, hosted in the same SQL Server or in a remote SQL Server instance, keeping the data in a consistent state.

SQL Server复制是一种数据分发技术，用于将数据库数据和对象从一个数据库复制和同步到另一个数据库，该数据库托管在同一SQL Server或远程SQL Server实例中，以使数据保持一致状态。

Q2: What is the difference between the Transactional Replication and the Snapshot Replication?

Q2：事务复制和快照复制有什么区别？

Both the Transactional replication and Snapshot replication start the initial synchronization by creating a full copy of the publication database articles and apply this copy to the subscription database.

事务复制和快照复制都通过创建发布数据库项目的完整副本来开始初始同步，并将此副本应用于订阅数据库。

In the Transaction replication, all changes that occurred at the Publisher side after taking the snapshot will be copied and applied to the Subscriber side continuously.

在事务复制中，拍摄快照后在发布者端发生的所有更改将被复制并连续应用于订阅者端。

This is not the case with the Snapshot replication, where the next synchronization will occur when a new snapshot is taken from the Publisher side to be applied to the Subscriber again.

快照复制不是这种情况，当从发布者端获取新快照以再次应用于订阅者时，下一次同步将发生。

Q3: What is special with the Merge Replication?

Q3：合并复制有什么特别之处？

In the Merge replication, the Subscriber will download a copy of the Publisher database data and objects at first connect. When the Subscriber connects to the network again, it will upload all changes to the Publisher database then download all changes from the Publisher again, that are performed by all Subscribers, to keep the data synchronized and consistent.

在合并复制