TransPublication.ValidateSubscriptions 메서드

Invokes inline publication validation for the specified subscription.

네임스페이스:  Microsoft.SqlServer.Replication
어셈블리:  Microsoft.SqlServer.Rmo(Microsoft.SqlServer.Rmo.dll)

public void ValidateSubscriptions(
	string[] subscriberNames,
	string[] subscriptionDBs,
	ValidationOption validationOption,
	ValidationMethod validationMethod,
	bool shutdownAgent
)

매개 변수

subscriberNames
유형: System.String[]
An array of String objects that specifies the names of the Subscribers.
subscriptionDBs
유형: System.String[]
An array of String objects that specifies the names of the subscription databases.
validationOption
유형: Microsoft.SqlServer.Replication.ValidationOption
A ValidationOption object value that specifies the type of validation being performed.
validationMethod
유형: Microsoft.SqlServer.Replication.ValidationMethod
A ValidationMethod object value that specifies options for rowcount validation.
shutdownAgent
유형: System.Boolean
A Boolean value. If true, the Distribution Agent is shut down immediately after validation. If false, the Distribution Agent continues to run.

The result of the validation operation is written to the agent history, which is viewed using Replication Monitor.

The result of the validation is written to the agent history, which is viewed using Replication Monitor. For more information, see 복제 모니터링.

The ValidateSubscriptions 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.

Calling ValidateSubscriptions is equivalent to executing sp_marksubscriptionvalidation and sp_article_validation.

커뮤니티 추가 항목

추가
표시: