发布和订阅的问题

Question

  数据库版本是2008，环境中有一台数据库作为发布角色，另有两台数据库服务器是订阅角色，之前运行良好，今天在发布上调整了表结构，重新定义发布和订阅，目前两台订阅服务器有一台没有问题，大家帮忙分析什么原因？

Answer 1

另一台什么原因？出错还是？

---

If you think one reply solves your problem, please mark it as An Answer, if you think someone's reply helps you, please mark it as a Proposed Answer

Help by clicking：
Click here to donate your rice to the poor
Click to Donate
Click to feed Dogs & Cats

Found any spamming-senders? Please report at: Spam Report

Answer 2

估计的报错就是上面的截图

Answer 3

Which replication do you use? Any detailed error message in sql server log? Did you enable replicate schema changes? If so, don't need reinitial replication. If like to replicate new table, just add it to article.

Answer 4

你这是典型的资源占用，  发布订阅又称读写分离，  顾名思义是不能同时两台机器对同一台机器的数据库操作的， 你把两台机器对那太机器的sql读写分离的时间岔开一下。

Answer 5

Not sure what you meant. One publisher with two subscribers shouldn't be issue, we have one publisher with six subscribers and work fine.