March 19, 2008 at 9:19 am
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]
March 19, 2008 at 2:36 pm
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]
March 19, 2008 at 7:52 pm
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]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply