Data Validation-Transactional Replication

• Lookup_BI

  SSCrazy

  Points: 2964

  More actions

  March 19, 2008 at 9:19 am

  #180212

  Hi All...

  This is my first time solving replication problem.Do help me out .

  We have two servers A [Publisher] and B [Subscriber]. Today users complained there is data mismatch.I just did a Select Top 10 records from both A & B, and there is differences in the records.I have to fix this problem by today.What are the steps I should take to find the

  Validate the mismatch records?

  Sync both tables ? Same records on both ends

  Ensure Mismatch does not happend in future?

  There is no error mssg that indicate's failure of replication

  [font="TimesNewRoman"] “I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison[/font]

• Lookup_BI

  SSCrazy

  Points: 2964

  More actions

  March 19, 2008 at 2:36 pm

  #791718

  Hi,

  I just checked further. This transactional replication is between an indexed view and a table.

  This problem started 2 days ago.No error mssg, nothing in log files,

  Users are complaining in consistency in data.

  What should I do ? I need to get this solved by Tom as this is a production issue.

  [font="TimesNewRoman"] “I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison[/font]

• Lookup_BI

  SSCrazy

  Points: 2964

  More actions

  March 19, 2008 at 7:52 pm

  #791838

  After futher checking, I decided to reconfigure the transactional replication of an indexed view from Server A to table on Server B.

  Anyone has complete step by step guide for me to follow?

  [font="TimesNewRoman"] “I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison[/font]