开发者

Distributor- meaning of- configured on separate database server instances?

开发者 https://www.devze.com 2023-01-07 19:10 出处:网络
From the following definition of a Distributor: The Distributor is a database instance that acts as a store for replication specific data associated with one or more Publishers. Each Publisher is as

From the following definition of a Distributor:

The Distributor is a database instance that acts as a store for replication specific data associated with one or more Publishers. Each Publisher is associated with a single database (known as a distribution database) at the Distributor. The distribution database stores replication status data, metadata about the publication, and, in some cases, acts as a queue for data moving from the Publisher to the Subscribers. In many cases, a single database server instance acts as both the Publisher and the Distributor. This is known as a local Distributor. When the Publisher and the Distributor are configured on separate database server instances, the Distributor is known as a remote Distributor.

I am looking to understand the following phrase:

configured on separate database server instances

Does this mean on servers running on different computers? Or on one computer, one sq开发者_如何学运维l server, with different instance names?


"configured on separate database server instances" means on two independent SQL server instances; whether they are installed on the same physical machine

e.g. publisher = server\instance11, distributor = server\instance2

or on two distinct machines

e.g. publisher = server1\instance , distributor = server2\instance

Remote Distribution is any case where the publisher and the distributor are not the same SQL server instance.

0

精彩评论

暂无评论...
验证码 换一张
取 消