Home
  •  

Microsoft.SQLServer.2016.Replication.DistributorMSSQL 2016 Replication: Distributor

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

SQL Server 2016 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.Library.GenericDistributor
AbstractFalse
HostedTrue
SingletonFalse
ExtensionFalse
AccessibilityPublic
ElementIdf1b69336-0909-ea6b-9ec7-87e99e986a7d

Class Hierarchy:

Class Properties:

Property Name Type Display Name (ENU) Description (ENU) Key Max Length Min Length Case Sensitive Default Value EnumType
System.Entity:
DisplayName  string  Display Name Display name of the object. false 4000  0  False     
System.ConfigItem:
ObjectStatus  enum  Object Status Object status false 256  0    System.ConfigItem.ObjectStatusEnum.Active  System.ConfigItem.ObjectStatusEnum 
AssetStatus  enum  Asset Status Asset status false 256  0      System.ConfigItem.AssetStatusEnum 
Notes  richtext  Notes Notes false 4000  0       
Microsoft.SQLServer.Replication.Library.GenericDistributor:
InstanceName  string  Instance Name The name of the instance which runs the agent true 256  0  False     
ServiceName  string  Service Name false 256  0  False     
AgentServiceName  string  SQL Agent Service Name false 256  0  False     
Publishers  string  Publishers List of Instances involved false 256  0  False     
DistributionDatabases  string  Distribution Databases The list of distributor databases false 4000  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.2016.Replication.Distributor" Base="MSRL!Microsoft.SQLServer.Replication.Library.GenericDistributor" Accessibility="Public" Abstract="false" Hosted="true" Singleton="false"/>