Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
 Posted - 2008-03-19 : 11:46:20
|
Hi All... This is my first time solving replication problem for me.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 ?Ensure Mismatch does not happend in future? There is no error mssg that indicate's failure of replication |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-19 : 11:52:24
|
| 1) Check Replication Monitor and make sure all jobs of replications are running well in Publishers and subscribers as well.2) Check log reader agent,Syncronization status3) Is that in same location or different location?4) Validate subscribers as well. |
 |
|
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2008-03-19 : 12:05:11
|
| 3)They are at different locations.4)How do I do this ? Validate subscribers as well. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-19 : 12:13:37
|
| check this out:http://msdn2.microsoft.com/en-us/library/aa178831(SQL.80).aspx |
|
|
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2008-03-19 : 16:35:05
|
| 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 ? |
|
|
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2008-03-19 : 21:53:10
|
| 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? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-21 : 00:26:22
|
| Why can't put same indexed view on server b? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-21 : 01:39:57
|
| You can't just SELECT TOP 10 from both tables without an ORDER BY. An ORDER BY must be included so that you are viewing the same data in the same order.To see what data is missing:select * from publisher..table1 pwhere not exists (select * from subscriber.dbo.table1 s where p.pk = s.pk)If you need to do a row by row comparison instead, then I'd suggest deleting replication and then setting it back up again and making sure that a snapshot runs to copy the data over.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Transactional Replication Mismatch Data