The Distributor is not available.

Question

之前有完成过Replication,后因为硬盘损坏,导致数据库坏掉,经过备份还原,数据库正常,但是数据库上确始终有一个手的表记,并且在该服务器上无法配置replication,每一次点击'配置replication'按钮都提示:The Distributor is not available.Error 208 Invalid object name 'msdb.Msdistpublishers'.的错误,点击其他的replication按钮都出错.:比如删除replication/public等都有问题.

 

Answer 1

Tried config distributor first?

Answer 2

试过了,没用.一点击这按钮就出错.就出上面的错误.

Answer 3

Which edition of sql you have?

Answer 4

1) : SQL 2000.

I find that the database has been at replication state.but I have been deleted all configuration.

 

 

 

 

Answer 5

Sounds you didn't remove replication properly, try clean it up with sp_dboption.

Answer 6

exec sp_dboption 'MyDataBaseName,'published',false

Error:

Server: Msg 208, Level 16, State 1, Procedure sp_helpdistributor, Line 97

Invalid object name 'msdb.dbo.MSdistpublishers'.

Server: Msg 20029, Level 16, State 1, Procedure sp_MSpublishdb, Line 55

 

The Distributor has not been installed correctly. Could not disable database for publishing.

 

Answer 7

Config distributor, clean up publisher then remove distributor.