SQL Server 2014 Distributor is a SQL Server instance that acts as a store for replication specific data associated with one or more Publishers
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.
Base Class | Microsoft.SQLServer.Replication.Library.GenericDistributor |
Abstract | False |
Hosted | True |
Singleton | False |
Extension | False |
Accessibility | Public |
ElementId | 690a5500-8668-a782-9c75-644410a5f1c6 |
Property Name | Type | Display Name (ENU) | Description (ENU) | Key | Max Length | Min Length | Case Sensitive | Default Value | EnumType |
---|---|---|---|---|---|---|---|---|---|
System.Entity: | |||||||||
string | Display Name | Display name of the object. | false | 4000 | 0 | False | |||
System.ConfigItem: | |||||||||
enum | Object Status | Object status | false | 256 | 0 | System.ConfigItem.ObjectStatusEnum.Active | System.ConfigItem.ObjectStatusEnum | ||
enum | Asset Status | Asset status | false | 256 | 0 | System.ConfigItem.AssetStatusEnum | |||
richtext | Notes | Notes | false | 4000 | 0 | ||||
Microsoft.SQLServer.Replication.Library.GenericDistributor: | |||||||||
string | Instance Name | The name of the instance which runs the agent | true | 256 | 0 | False | |||
string | Service Name | false | 256 | 0 | False | ||||
string | SQL Agent Service Name | false | 256 | 0 | False | ||||
string | Publishers | List of Instances involved | false | 256 | 0 | False | |||
string | Distribution Databases | The list of distributor databases | false | 256 | 0 | False | |||
string | Connection String | Full Name of MS SQL Server instance | false | 256 | 0 | False | |||
string | Performance Counter Object | Performance Monitor object name for SQL Server Instance | false | 256 | 0 | False |
<ClassType ID="Microsoft.SQLServer.2014.Replication.Distributor" Base="MSRL!Microsoft.SQLServer.Replication.Library.GenericDistributor" Accessibility="Public" Abstract="false" Hosted="true" Singleton="false"/>