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 |
|
kirandbasql
Starting Member
4 Posts |
 Posted - 2009-03-05 : 22:54:13
|
| I’m experiencing this issue between two tables set under Transactional Replication in SQL 2K5.Issue: Table A and Table B are under replication.Both are running on SQL 2k5 on different servers.Synchronization is happening good.No Errors logged.A particular set of data ( rows ) is not getting replicated in the subscriber. Rest all data is getting filled from A to BIs anyone familiar with such an issue ?Thanks in advance. ? |
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2009-03-05 : 23:02:47
|
| What does Logreader agent and Distribution agent history log says? Did you notice any error/warnings etc. |
 |
|
|
kirandbasql
Starting Member
4 Posts |
Posted - 2009-03-06 : 00:17:04
|
| no error showing. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-03-06 : 09:03:44
|
quote:
Originally posted by kirandbasql
I’m experiencing this issue between two tables set under Transactional Replication in SQL 2K5.Issue: Table A and Table B are under replication.Both are running on SQL 2k5 on different servers.Synchronization is happening good.No Errors logged.A particular set of data ( rows ) is not getting replicated in the subscriber.Can you be more clear on this? Rest all data is getting filled from A to BIs anyone familiar with such an issue ?Thanks in advance. ?
|
|
|
|
kumarich1
Yak Posting Veteran
99 Posts |
Posted - 2009-03-06 : 15:34:03
|
| Check may be there are filters. That's why some data is not getting replicated. |
|
|
|
|
|
|
replication