Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Provides the functionality of the Replication Snapshot Agent.
The following tables list the members exposed by the SnapshotGenerationAgent type.
Public Constructors
| Name | Description | |
|---|---|---|
| SnapshotGenerationAgent | Creates an instance of the SnapshotGenerationAgent class. |
Top
Public Properties
| Name | Description | |
|---|---|---|
.gif "ms150049.pubproperty(en-US,SQL.90).gif") |
AbortPolicy | Gets or sets how running replication agent threads are terminated when an unanticipated shutdown occurs. (inherited from AgentCore) |
|
BcpBatchSize | Gets or set the number of rows to send to the Distributor in a bulk copy operation. |
|
ComErrorCollection | Returns information on errors that occur during agent execution. (inherited from AgentCore) |
|
Distributor | Gets or sets the name of the instance of SQL Server acting as the Distributor for the publication. |
|
DistributorDeadlockPriority | Gets or sets the priority of the Snapshot Agent connection to the Distributor when a deadlock occurs. |
|
DistributorEncryptedPassword | |
|
DistributorEncryptionLevel | Gets of sets the level of Secure Sockets Layer (SSL) encryption used by the Snapshot Agent when connecting to the Distributor. |
|
DistributorLogin | Gets or sets the login name used when connecting locally to the Distributor using SQL Server Authentication. |
|
DistributorNetworkLibrary | |
|
DistributorPassword | Sets the password used when connecting locally to the Distributor using SQL Server Authentication. |
|
DistributorSecurityMode | Gets or sets the security mode used when connecting locally to the Distributor. |
|
DynamicFilterHostName | Gets or sets the value supplied to the HOST_NAME function used in a parameterized row filter. |
|
DynamicFilterLogin | Gets or sets the value supplied to the SUSER_SNAME function used in a parameterized row filter. |
|
DynamicSnapshotLocation | Gets or sets the location of the partitioned snapshot for a subscription to a merge publication that is defined based-on a parameterized row filter. |
|
FieldDelimiter | Gets or sets the character or character sequence that marks the end of a field in the SQL Server bulk-copy data file. |
|
FlatExceptionCollection | (inherited from AgentCore ) |
|
HistoryVerboseLevel | Gets or sets the amount of history logged during agent execution. (inherited from AgentCore) |
|
HRBcpBlocks | |
|
HRBcpBlockSize | |
|
HRBcpDynamicBlocks | |
|
LoginTimeout | Get or sets the number of seconds before the login times out for connections made by the agent. (inherited from AgentCore) |
|
MaxBcpThreads | Gets or sets the number of bulk copy operations that can be performed in parallel. |
|
MaxNetworkOptimization | Gets or sets whether out-of-partition deletes are sent to the Subscriber. |
|
OnetimeDynamicSnapshot | |
|
Output | Get or sets the name and path of the agent output file. (inherited from AgentCore) |
|
OutputVerboseLevel | Gets or sets the level of detail of information written to the agent output file. (inherited from AgentCore) |
|
PacketSize | (inherited from AgentCore ) |
|
ProfileName | Gets or sets an agent profile to use when running the agent. (inherited from AgentCore) |
|
Publication | Gets or sets the name of the publication. |
|
Publisher | Gets or sets the name of the instance of SQL Server that is the Publisher. |
|
PublisherDatabase | Gets or sets the name of the publication database. |
|
PublisherDeadlockPriority | Gets or sets the priority of the Snapshot Agent connection to the Publisher when a deadlock occurs. |
|
PublisherEncryptedPassword | |
|
PublisherEncryptionLevel | Gets of sets the level of Secure Sockets Layer (SSL) encryption used by the Snapshot Agent when connecting to the Distributor. |
|
PublisherFailoverPartner | Gets or sets the failover partner instance of SQL Server participating in a database mirroring session with the publication database. (inherited from AgentCore) |
|
PublisherLogin | Gets or sets the login name used when connecting to the Publisher using SQL Server Authentication. |
|
PublisherNetworkLibrary | |
|
PublisherPassword | Sets the password used when connecting to the Publisher using SQL Server Authentication. |
|
PublisherSecurityMode | Gets or sets the security mode used when connecting to the Publisher. |
|
QueryTimeout | Get or sets the number of seconds before a query times out. (inherited from AgentCore) |
|
ReplicationType | Gets or sets the type of publication. |
|
RowDelimiter | Gets or sets the character or character sequence that marks the end of a row in the SQL Server bulk-copy data file. |
|
SecureDistributorEncryptedPassword | |
|
SecureDistributorPassword | Sets the password (as a SecureString object) used when connecting locally to the Distributor using SQL Server Authentication. |
|
SecurePublisherEncryptedPassword | |
|
SecurePublisherPassword | Sets the password (as a SecureString object) used when connecting to the Publisher using SQL Server Authentication. |
|
StartQueueTimeout | Gets or sets the time that the Snapshot Agent waits when the maximum number of concurrent partitioned snapshot processes for a merge publication are already running. |
|
Supports70Subscribers | Gets or sets whether the generated snapshot supports SQL Server 7.0 Subscribers. |
Top
Public Methods
(see also Protected Methods )
| Name | Description | |
|---|---|---|
.gif "ms150049.pubmethod(en-US,SQL.90).gif") |
Abort | (inherited from AgentCore ) |
|
CreateObjRef | (inherited from MarshalByRefObject ) |
|
Equals | Overloaded. (inherited from Object ) |
|
GenerateSnapshot | Starts the Snapshot Agent to generate the snapshot. |
|
GetHashCode | (inherited from Object ) |
|
GetLifetimeService | (inherited from MarshalByRefObject ) |
|
GetType | (inherited from Object ) |
|
InitializeLifetimeService | (inherited from MarshalByRefObject ) |
.gif "ms150049.static(en-US,SQL.90).gif") |
ReferenceEquals | (inherited from Object ) |
|
ResetParametersToDefault | (inherited from AgentCore ) |
|
ToString | (inherited from Object ) |
Top
Protected Methods
| Name | Description | |
|---|---|---|
.gif "ms150049.protmethod(en-US,SQL.90).gif") |
Finalize | (inherited from Object ) |
|
MemberwiseClone | Overloaded. (inherited from MarshalByRefObject ) |
Top
Public Events
| Name | Description | |
|---|---|---|
.gif "ms150049.pubevent(en-US,SQL.90).gif") |
ComStatus | (inherited from AgentCore ) |
|
Status | Occurs when a running agent returns status information. (inherited from AgentCore) |
Top
Explicit Interface Implementations
| Name | Description | |
|---|---|---|
| Microsoft.SqlServer.Replication.ISnapshotGenerationAgent.ResetParametersToDefault |
Top
See Also
Reference
SnapshotGenerationAgent Class
Microsoft.SqlServer.Replication Namespace
Other Resources
How to: Create the Initial Snapshot (RMO Programming)
How to: Create a Snapshot for a Merge Publication with Parameterized Filters (RMO Programming)
Replication Snapshot Agent