CODEWITHSUNDEEP
sql-serverreplicationtransactional-replication
Jason Clark
Jason Clark

Reputation: 1425

How to check for Publisher and Subscriber in transactional replication?

In transactional replication, at a particular point of time how can i check and confirm whether data at Publisher and Subscriber is same? I don't want to check latency/trace token - as latency will only tell how much subscriber is behind from Publisher/distributor?

Upvotes: 0

Views: 1216

Answers (1)

Brandon Williams
Brandon Williams

Reputation: 3755

You can do a data validation to see how out of sync you are. Details on validating data can be found in Validate Replicated Data.

You can also use the tablediff utility or SQL Data Compare to see how out of sync you are and generate a T-SQL script to bring the data back into convergence.

Upvotes: 1

Related Questions