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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-06 : 23:21:25
|
Peter writes "I have started using SQL 7.0 SP2 Replication. Publisher is an Windows NT SP5 Alpha Server. Subscribers Windows NT SP5 Intel.
My first attempt was creating two publications. One was transactional the other snapshot. The articles of each publication come from the same database.
The first issue, when I created Push subscriptions via Wizard to both publications, it appears only one distribution agent is created per subscriber. I wanted an every minute update for the transactional replication and an every night update for the snapshot replication. I want subscribers to have immediate update option for transactional articles but not for snapshot articles.
The second issue I found that subscribers were getting "Row cannot be located for updating. Some values may have been changed since it was last read" messages. I found that the timestamp values between publisher and subscribers were different. I found no errors in logs that would indicate that these transactions were not being distributed. I have 5 subscribers that have had these problems in different records.
The third issue is the lack of documentation of the "Synchronize Now" function when you right click a subscriber's publication in SQL Server Enterprise Manager" I wasn't sure whether or not to use this each time the second issue occured." |
|
|
|
|
|
Replication Issues for First Timer