SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2012

Product Documentation

Developer Reference for SQL Server 2012

Developer Reference

Developer's Guide (Replication)

Microsoft.SqlServer.Replication

AddColumnOption Enumeration

AgentJobHistoryInfo Class

AgentProfile Class

AgentProfileParameter Class

AgentProfileParameterInfo Class

AgentProfileTypeOption Enumeration

AgentType Enumeration

Article Class

ArticleConflict Class

ArticleDatatypeMappingOptions Enumeration

ArticleOptions Enumeration

AuthenticationMethod Enumeration

AutomaticReinitializationPolicies Enumeration

BusinessLogicHandler Class

CheckPermissionOptions Enumeration

CommandOptions Enumeration

ConflictPolicyOption Enumeration

ConnectionSecurityContext Class

CreationScriptOptions Enumeration

CustomResolver Class

DatabaseCompatibilityLevel Enumeration

DdlReplicationOptions Enumeration

DistributionArticle Class

DistributionArticleCollection Class

DistributionDatabase Class

DistributionDatabaseCollection Class

DistributionPublication Class

DistributionPublicationCollection Class

DistributionPublisher Class

DistributionPublisherCollection Class

DistributionSubscription Class

DistributionSubscriptionCollection Class

DtsPackageLocationOption Enumeration

FailoverMode Enumeration

FilterTypes Enumeration

HeterogeneousColumn Class

HeterogeneousTable Class

IConnectionSecurityContext Interface

IdentityRangeInfo Class

IdentityRangeManagementOption Enumeration

InitialSyncType Enumeration

IProcessSecurityContext Interface

IReplicationDBObject Interface

LastValidationDateTime Class

LightPublication Class

MergeArticle Class

MergeArticleCollection Class

MergeArticleState Enumeration

MergeConflictCount Class

MergeDynamicSnapshotJob Class

MergeJoinFilter Class

MergePartition Class

MergePublication Class

MergePublicationCollection Class

MergePullSubscription Class

MergePullSubscriptionCollection Class

MergeSessionDetail Class

MergeSessionDetailType Enumeration

MergeSessionError Class

MergeSessionPhase Enumeration

MergeSessionStatus Enumeration

MergeSessionSummary Class

MergeSubscriberMonitor Class

MergeSubscriberType Enumeration

MergeSubscription Class

MergeSubscriptionCollection Class

MonitorCacheRefreshPolicy Enumeration

MonitorThreshold Class

PartitionGroupsOption Enumeration

PartitionOptions Enumeration

PendingCommandInfo Class

PreCreationOption Enumeration

Publication Class

PublicationAccess Class

PublicationArticle Class

PublicationAttributes Enumeration

PublicationCompatibilityLevel Enumeration

PublicationMonitor Class

PublicationMonitorCollection Class

PublicationType Enumeration

PublisherConnectionSecurityContext Class

PublisherMonitor Class

PublisherMonitorCollection Class

PullSubscription Class

QueueOption Enumeration

RegisteredSubscriber Class

RegisteredSubscriberCollection Class

ReplicationAgentSchedule Class

ReplicationBaseCollection Class

ReplicationColumn Class

ReplicationDatabase Class

ReplicationDatabaseCollection Class

ReplicationMonitor Class

ReplicationObject Class

ReplicationSchemaBoundView Class

ReplicationSecurityMode Enumeration

ReplicationServer Class

ReplicationStatus Enumeration

ReplicationStatusAndWarning Class

ReplicationStoredProcedure Class

ReplicationTable Class

ReplicationUserDefinedAggregate Class

ReplicationUserDefinedFunction Class

ReplicationView Class

ReplicationWarnings Enumeration

ResynchronizeType Enumeration

RetentionPeriodUnits Enumeration

ScheduleConstant Enumeration

ScheduleFrequencySubDay Enumeration

ScheduleFrequencyType Enumeration

ScheduleRelativeIntervals Enumeration

ScriptOptions Enumeration

State Enumeration

SubscriberSubscription Class

SubscriberType Enumeration

SubscriberUploadOptions Enumeration

Subscription Class

SubscriptionBackupDeviceType Enumeration

SubscriptionBackupInformation Class

SubscriptionResultOption Enumeration

SubscriptionState Enumeration

SubscriptionSyncType Enumeration

SynchronizationPartner Class

TracerToken Class

TransArticle Class

TransArticleCollection Class

TransConflictCount Class

TransPublication Class

TransPublicationCollection Class

TransPullSubscription Class

TransPullSubscriptionCollection Class

TransSubscriberType Enumeration

TransSubscription Class

TransSubscriptionCollection Class

ValidationMethod Enumeration

ValidationOption Enumeration

VerifyResolverSignatureOption Enumeration

Minimize

This topic has not yet been rated - Rate this topic

FailoverMode Enumeration

SQL Server 2012

Enumerates the options available for an updating Subscriber to propagate changes back to the Publisher.

Namespace: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

public enum FailoverMode

	Member name	Description
	Immediate	The Publisher and Subscriber must be connected to update data at the Subscriber.
	Queued	The Publisher and Subscriber do not have to be connected to update data at the Subscriber. Updates can be made while the Subscriber or Publisher is offline.

This enumeration is used with transactional replication.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Reference

Microsoft.SqlServer.Replication Namespace

Other Resources

Updatable Subscriptions for Transactional Replication

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.