| Author |
Topic |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2006-01-25 : 06:43:01
|
| Hi,I have set up transactional replication with two publications from a single Publisher to two subscribers . These servers are all SQL 2000 servers. Now i just happen to check that the transaction and commands being delivered to these two subscribers are not the same. Sometimes for e.g I see that it delivers 26 transactions to one subscriber while it does not deliver anything on the other subscriber without any errors . It just states that no replicated transactions are available. So i am not sure that the replication is happening correctly on both servers and the data is in sync with the publisher. Is there any other way to cross- check or is it system defined ? I am not sure on this one. Need some advise or help please. Thanks. |
|
|
mblythe
Starting Member
16 Posts |
Posted - 2006-01-27 : 12:28:26
|
| What type of replication are you using? Are you using filters at all? Were you able to apply the snapshot successfully to both Subscribers?Michael Blythe Technical WriterSQL Server Replication - Microsoft --------------------------------------------------------------------------- This posting is provided "AS IS" with no warranties, and confers no rights. |
 |
|
|
admin001
Posting Yak Master
166 Posts |
Posted - 2006-01-27 : 13:51:38
|
| Hi Michael,Thanks for your response. We are using transactional replication from a single publisher to both subscribers with the default setting. No special settings are to filter. However when we start the syncronization , it does start correctly for both publications but for one it immediately shows that certain amount of transactions were delivered , but for the other publication it just states that no replicated transactions are available. After some time after I refresh I we see that the transactions are delivered successfully. Is data synchronization happening correctly or how to set it ,I am not sure. Users cannot see consistent data on both the publishers.Any further advise or help would be helpful. Tks once again. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-01-30 : 05:50:59
|
| After some time after I refresh I we see that the transactions are delivered successfully.So the correct number of transactions do get delivered?When you query the subscribers, do they come back with the same result sets? |
|
|
|
admin001
Posting Yak Master
166 Posts |
Posted - 2006-01-30 : 06:53:38
|
| Hi RickD,Yes. The users connecting to the subscribers do get the data but not in syncronization with the other publication where it gets delivered instantly. the users have to wait for the data to arrive on this subscription where there is an problem. Is there any other way where we could check the syncronization of the data to these subscribers and why is the delay on one subscriber ?Thanks for your response. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-01-30 : 07:28:03
|
| Are the jobs set up to run every n mintues? Are the 2 servers in the same building? |
|
|
|
admin001
Posting Yak Master
166 Posts |
Posted - 2006-01-30 : 08:26:42
|
| Hi RickD,Yes the job is scheduled to run every 10 min and they are in the same building. Couldn't figure out much why this should happen. As per some tech articles the data syncronization should happen automatically once we manually start the sync on the two subscription. Any thoughts ? Thanks. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-01-30 : 08:33:55
|
| It seems it is happening automatically, but taking some time to get to the second subscriber. Do you know how long it is taking, as some time isn't too helpful when trying to find a reason for this behaviour.. |
|
|
|
admin001
Posting Yak Master
166 Posts |
Posted - 2006-01-30 : 10:07:40
|
| Hi RickD,Yes I fully understand that it is really not sufficient to track the problem. But at this point of time this is the only observation I have unless there's something else I can look into.Has it something to do with Identity issues that could probably lead to this behaviour ?Thanks. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-01-30 : 11:08:23
|
| No, because the identity fields should be set to Yes (not for replication) on transactional replications.If the time it takes to write is greater than 10-15 minutes, then there is a problem, if it is less than this time, then it is just using the schedule and you may want to look at changing this to be less than 10 mins.. |
|
|
|
admin001
Posting Yak Master
166 Posts |
Posted - 2006-01-30 : 11:20:45
|
| Thanks RickD for the inputs. Will check on that. |
|
|
|
|
Replication to two subscribers.