DistributionDatabase Members
Represents a distribution database at the Distributor.
The following tables list the members exposed by the DistributionDatabase type.
Public Constructors
Имя | Description | |
---|---|---|
DistributionDatabase | Overloaded. Creates a new instance of the DistributionDatabase class. |
В начало
Public Properties
Имя | Description | |
---|---|---|
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) |
В начало
Public Methods
(see also Protected Methods )
Имя | Description | |
---|---|---|
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) | |
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 ) |
В начало
Protected Methods
Имя | Description | |
---|---|---|
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 ) |
В начало
См. также
Справочник
DistributionDatabase Class
Microsoft.SqlServer.Replication Namespace
Другие ресурсы
How to: Configure Publishing and Distribution (RMO Programming)
How to: View and Modify Publisher and Distributor Properties (RMO Programming)