Export (0) Print
Expand All

MergePublication.ResynchronizeSubscription Method

Resynchronizes a merge subscription to a known validation state that you specify.

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

public void ResynchronizeSubscription(
	string subscriber,
	string subscriptionDB,
	ResynchronizeType synchronizeType,
	string dateTime


Type: System.String
A String value that specifies the Subscriber.
Type: System.String
A String value that specifies the subscription database.
Type: Microsoft.SqlServer.Replication.ResynchronizeType
A ResynchronizeType value that specifies the resynchronization type.
Type: System.String
A String value that represents the date and time from which the changes are resynchronized.

The ResynchronizeSubscription method allows you to force convergence or synchronize the subscription database to a specific point in time, such as the last time there was a successful validation, or to a specified date. The snapshot is not reapplied when resynchronizing a subscription using this method.

The ReadLastValidationDateTimes method can be used to determine the date and time of the last successful validation of the subscription

Calling ResynchronizeSubscription is equivalent to executing sp_resyncmergesubscription.

The ResynchronizeSubscription method can only be called by members of the sysadmin fixed server role at the Publisher or by members of the db_owner fixed database role on the publication database.

The ResynchronizeSubscription method is available only for instances of Microsoft SQL Server 2000 and Microsoft SQL Server 2005.

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

Community Additions

© 2014 Microsoft