Condividi tramite


DistributionDatabase Members

Represents a distribution database at the Distributor.

The following tables list the members exposed by the DistributionDatabase type.

Public Constructors

  Nome Description
DistributionDatabase Overloaded. Creates a new instance of the DistributionDatabase class.

Torna all'inizio

Public Properties

  Nome Description
ms155987.pubproperty(it-it,SQL.90).gif CachePropertyChanges  Gets or sets whether to cache changes made to the replication properties or to apply them immediately. (inherited from ReplicationObject)
ms155987.pubproperty(it-it,SQL.90).gif ConnectionContext  Gets or sets the connection to an instance of Microsoft SQL Server. (inherited from ReplicationObject)
ms155987.pubproperty(it-it,SQL.90).gif DataFile Gets or sets the name of the data file for the distribution database.
ms155987.pubproperty(it-it,SQL.90).gif DataFileSize Gets or sets the size of the primary database file for the distribution database.
ms155987.pubproperty(it-it,SQL.90).gif DataFolder Gets or sets the path to the directory that contains the data file for the distribution database.
ms155987.pubproperty(it-it,SQL.90).gif DistributionCleanupTaskName Gets the name of the SQL Server Agent job that is responsible for cleaning up the replication tables in the distribution.
ms155987.pubproperty(it-it,SQL.90).gif DistributorSecurity Gets the security context used to connect to the Distributor to create the distribution database.
ms155987.pubproperty(it-it,SQL.90).gif HistoryCleanupTaskName Gets the name of the SQL Server Agent job that is responsible for cleaning up replication history tables.
ms155987.pubproperty(it-it,SQL.90).gif HistoryRetention Gets or sets the length of time, in hours, replication agent history data is to be retained.
ms155987.pubproperty(it-it,SQL.90).gif IsExistingObject  Gets whether the object exists on the server or not. (inherited from ReplicationObject)
ms155987.pubproperty(it-it,SQL.90).gif LogFile Gets or sets the name of the file that stores database transaction log records.
ms155987.pubproperty(it-it,SQL.90).gif LogFileSize Gets or sets the size of the file that stores database transaction log records.
ms155987.pubproperty(it-it,SQL.90).gif LogFolder Gets or sets the path to the directory where the file that stores database transaction log records is located.
ms155987.pubproperty(it-it,SQL.90).gif MaxDistributionRetention Gets or sets the maximum retention period, in hours, before transactions are deleted from the distribution database.
ms155987.pubproperty(it-it,SQL.90).gif MinDistributionRetention Gets or sets the minimum retention period, in hours, before transactions are deleted from the distribution database.
ms155987.pubproperty(it-it,SQL.90).gif Name Gets or sets the name of the distribution database.
ms155987.pubproperty(it-it,SQL.90).gif QueueReaderAgentExists Gets or sets whether the Queue Reader Agent job has been created for this distribution database.
ms155987.pubproperty(it-it,SQL.90).gif QueueReaderAgentName Gets or sets the name of the Queue Reader Agent job created for this distribution database.
ms155987.pubproperty(it-it,SQL.90).gif QueueReaderAgentProcessSecurity Gets the agent process security context for running the Queue Reader Agent job.
ms155987.pubproperty(it-it,SQL.90).gif SqlServerName  Gets the name of the Microsoft SQL Server instance to which this object is connected. (inherited from ReplicationObject)
ms155987.pubproperty(it-it,SQL.90).gif UserData  Gets or sets an object property that allows users to attach their own data to the object. (inherited from ReplicationObject)

Torna all'inizio

Public Methods

(see also Protected Methods )

  Nome Description
ms155987.pubmethod(it-it,SQL.90).gif CleanUpAnonymousSubscription Removes metadata for anonymous subscriptions at the Distributor.
ms155987.pubmethod(it-it,SQL.90).gif CommitPropertyChanges  Sends all the cached property change statements to the instance of Microsoft SQL Server. (inherited from ReplicationObject)
ms155987.pubmethod(it-it,SQL.90).gif Create Creates the distribution database.
ms155987.pubmethod(it-it,SQL.90).gif CreateQueueReaderAgent Creates the Queue Reader Agent job on the distribution database.
ms155987.pubmethod(it-it,SQL.90).gif Decouple  Decouples the referenced replication object from the server. (inherited from ReplicationObject)
ms155987.pubmethod(it-it,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms155987.pubmethod(it-it,SQL.90).gif GetHashCode  (inherited from Object )
ms155987.pubmethod(it-it,SQL.90).gif GetType  (inherited from Object )
ms155987.pubmethod(it-it,SQL.90).gif Load  Loads the properties of an existing object from the server. (inherited from ReplicationObject)
ms155987.pubmethod(it-it,SQL.90).gif LoadProperties  Loads the properties of an existing object from the server. (inherited from ReplicationObject)
ms155987.pubmethod(it-it,SQL.90).gifms155987.static(it-it,SQL.90).gif ReferenceEquals  (inherited from Object )
ms155987.pubmethod(it-it,SQL.90).gif Refresh  Reloads the properties of the object. (inherited from ReplicationObject)
ms155987.pubmethod(it-it,SQL.90).gif Remove Deletes the distribution database.
ms155987.pubmethod(it-it,SQL.90).gif Script Generates a Transact-SQL script that can be used to create or delete the distribution database that the object represents.
ms155987.pubmethod(it-it,SQL.90).gif ToString  (inherited from Object )

Torna all'inizio

Protected Methods

  Nome Description
ms155987.protmethod(it-it,SQL.90).gif CheckValidCreation  (inherited from ReplicationObject )
ms155987.protmethod(it-it,SQL.90).gif CheckValidDefinition  (inherited from ReplicationObject )
ms155987.protmethod(it-it,SQL.90).gif Finalize  (inherited from Object )
ms155987.protmethod(it-it,SQL.90).gif GetChangeCommand  (inherited from ReplicationObject )
ms155987.protmethod(it-it,SQL.90).gif GetCreateCommand  (inherited from ReplicationObject )
ms155987.protmethod(it-it,SQL.90).gif GetDropCommand  (inherited from ReplicationObject )
ms155987.protmethod(it-it,SQL.90).gif InternalRefresh  (inherited from ReplicationObject )
ms155987.protmethod(it-it,SQL.90).gif MemberwiseClone  (inherited from Object )

Torna all'inizio

Vedere anche

Riferimento

DistributionDatabase Class
Microsoft.SqlServer.Replication Namespace

Altre risorse

How to: Configure Publishing and Distribution (RMO Programming)
How to: View and Modify Publisher and Distributor Properties (RMO Programming)