sqlserver2000发布订阅

sql2000创建的数据库发布与订阅，

经常出现如下错误：

1.日志读取器：“超时已过期.NOTE:The step was retried the requested number of times(10) without succeeding.The step failed.”

2.请求订阅：“超时已过期”

数据库发布与订阅出现问题之前，曾出现订阅段服务器数据库日志已满，之后对发布服务器的数据库和订阅服务器的数据库进行过数据库收缩。

之后订阅发布服务器频繁出现上述错误。

 

 尝试方案一：

 

I would venture to say that as your backup server died several months ago your publications have expired subscriptions.

I would drop the subscriptions, let the clean up task do its work, and then create your subscriptions.

You probably have the anonymous subscription option selected.

At this point your best option is to script out the publications, drop them, run the clean up agent, and then shrink the tlogs.

 

最终解决方案：

1、将数据库的发布与订阅删除；

2、收缩数据库；

3、重新建立数据库的发布与订阅；

OK，状况不再出现了。

 

转载于:https://www.cnblogs.com/gsk99/archive/2011/11/20/2255975.html