Home
  •  

Microsoft.SQLServer.Replication.Windows.DistributorMSSQL on Windows Replication: Distributor

Microsoft.SQLServer.Replication.Windows.Distributor (ClassType)

SQL Server on Windows Distributor is a SQL Server instance that acts as a store for replication specific data associated with one or more Publishers

Knowledge Base article:

Summary

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.

Element properties:

Base ClassMicrosoft.SQLServer.Replication.Core.GenericDistributor
AbstractFalse
HostedTrue
SingletonFalse
ExtensionFalse
AccessibilityPublic
ElementId465e9601-be5f-ad8f-0b96-85e338a872fa

Class Hierarchy:

Class Properties:

Property Name Type Display Name (ENU) Description (ENU) Key Max Length Min Length Case Sensitive
System.Entity:
DisplayName  string  Display Name Display name of the object. false 4000  0  False 
Microsoft.SQLServer.Replication.Core.GenericDistributor:
Publishers  string  Publishers List of Instances involved false 4000  0  False 
DistributionDatabases  string  Distribution Databases The list of distributor databases false 4000  0  False 
ServiceName  string  Service Name false 256  0  False 
AgentServiceName  string  SQL Agent Service Name false 256  0  False 
ConnectionString  string  Connection String Full Name of MS SQL Server instance false 256  0  False 
PerformanceCounterObject  string  Performance Counter Object Performance Monitor object name for SQL Server Instance false 256  0  False 

Health Model:

Source Code:

<ClassType ID="Microsoft.SQLServer.Replication.Windows.Distributor" Base="MSRL!Microsoft.SQLServer.Replication.Core.GenericDistributor" Accessibility="Public" Abstract="false" Hosted="true" Singleton="false"/>