DistributionDatabase Members
Represents a distribution database at the Distributor.
The following tables list the members exposed by the DistributionDatabase type.
Public Constructors
| Name | Description | |
|---|---|---|
| DistributionDatabase | Overloaded. Creates a new instance of the DistributionDatabase class. |
Top
Public Properties
| Name | Description | |
|---|---|---|
.gif "ms155987.pubproperty(en-US,SQL.90).gif") |
CachePropertyChanges | Gets or sets whether to cache changes made to the replication properties or to apply them immediately. (inherited from ReplicationObject) |
|
ConnectionContext | Gets or sets the connection to an instance of Microsoft SQL Server. (inherited from ReplicationObject) |
|
DataFile | Gets or sets the name of the data file for the distribution database. |
|
DataFileSize | Gets or sets the size of the primary database file for the distribution database. |
|
DataFolder | Gets or sets the path to the directory that contains the data file for the distribution database. |
|
DistributionCleanupTaskName | Gets the name of the SQL Server Agent job that is responsible for cleaning up the replication tables in the distribution. |
|
DistributorSecurity | Gets the security context used to connect to the Distributor to create the distribution database. |
|
HistoryCleanupTaskName | Gets the name of the SQL Server Agent job that is responsible for cleaning up replication history tables. |
|
HistoryRetention | Gets or sets the length of time, in hours, replication agent history data is to be retained. |
|
IsExistingObject | Gets whether the object exists on the server or not. (inherited from ReplicationObject) |
|
LogFile | Gets or sets the name of the file that stores database transaction log records. |
|
LogFileSize | Gets or sets the size of the file that stores database transaction log records. |
|
LogFolder | Gets or sets the path to the directory where the file that stores database transaction log records is located. |
|
MaxDistributionRetention | Gets or sets the maximum retention period, in hours, before transactions are deleted from the distribution database. |
|
MinDistributionRetention | Gets or sets the minimum retention period, in hours, before transactions are deleted from the distribution database. |
|
Name | Gets or sets the name of the distribution database. |
|
QueueReaderAgentExists | Gets or sets whether the Queue Reader Agent job has been created for this distribution database. |
|
QueueReaderAgentName | Gets or sets the name of the Queue Reader Agent job created for this distribution database. |
|
QueueReaderAgentProcessSecurity | Gets the agent process security context for running the Queue Reader Agent job. |
|
SqlServerName | Gets the name of the Microsoft SQL Server instance to which this object is connected. (inherited from ReplicationObject) |
|
UserData | Gets or sets an object property that allows users to attach their own data to the object. (inherited from ReplicationObject) |
Top
Public Methods
(see also Protected Methods )
| Name | Description | |
|---|---|---|
.gif "ms155987.pubmethod(en-US,SQL.90).gif") |
CleanUpAnonymousSubscription | Removes metadata for anonymous subscriptions at the Distributor. |
|
CommitPropertyChanges | Sends all the cached property change statements to the instance of Microsoft SQL Server. (inherited from ReplicationObject) |
|
Create | Creates the distribution database. |
|
CreateQueueReaderAgent | Creates the Queue Reader Agent job on the distribution database. |
|
Decouple | Decouples the referenced replication object from the server. (inherited from ReplicationObject) |
|
Equals | Overloaded. (inherited from Object ) |
|
GetHashCode | (inherited from Object ) |
|
GetType | (inherited from Object ) |
|
Load | Loads the properties of an existing object from the server. (inherited from ReplicationObject) |
|
LoadProperties | Loads the properties of an existing object from the server. (inherited from ReplicationObject) |
.gif "ms155987.static(en-US,SQL.90).gif") |
ReferenceEquals | (inherited from Object ) |
|
Refresh | Reloads the properties of the object. (inherited from ReplicationObject) |
|
Remove | Deletes the distribution database. |
|
Script | Generates a Transact-SQL script that can be used to create or delete the distribution database that the object represents. |
|
ToString | (inherited from Object ) |
Top
Protected Methods
| Name | Description | |
|---|---|---|
.gif "ms155987.protmethod(en-US,SQL.90).gif") |
CheckValidCreation | (inherited from ReplicationObject ) |
|
CheckValidDefinition | (inherited from ReplicationObject ) |
|
Finalize | (inherited from Object ) |
|
GetChangeCommand | (inherited from ReplicationObject ) |
|
GetCreateCommand | (inherited from ReplicationObject ) |
|
GetDropCommand | (inherited from ReplicationObject ) |
|
InternalRefresh | (inherited from ReplicationObject ) |
|
MemberwiseClone | (inherited from Object ) |
Top
See Also
Reference
DistributionDatabase Class
Microsoft.SqlServer.Replication Namespace
Other Resources
How to: Configure Publishing and Distribution (RMO Programming)
How to: View and Modify Publisher and Distributor Properties (RMO Programming)