错误:存在分发数据库,​​但系统数据库中没有此类数据库

问题描述:

创建分发数据库时出现此错误。我正在尝试在sql server 2008上设置快照复制



标题:经销商属性

----------- -------------------



无法添加分发数据库''发行版''。



如需帮助,请单击:http://go.microsoft.com/fwlink?ProdName = Microsoft + SQL + Server&ProdVer = 10.50.1600.1&EvtSrc = Microsoft.SqlServer.Management.UI。 DistributorPropertiesErrorSR&EvtID = CantAddDistributionDB&LinkId = 20476



----------------------------- -

附加信息:



执行Transact-SQL语句或批处理时发生异常。 (Microsoft.SqlServer.ConnectionInfo)



--------------------------- ---



无法添加分发数据库''发行版''。此分发数据库已存在。

将数据库上下文更改为master。 (Microsoft SQL Server,错误:14119)



如需帮助,请单击:http://go.microsoft.com/fwlink?ProdName = Microsoft + SQL + Server&ProdVer = 10.50.1600&EvtSrc = MSSQLServer&EvtID = 14119&LinkId = 20476



------------------------- -----

按钮:



OK

---------- --------------------

I am getting this error while creating distribution database. I am trying to setup snapshot replication on sql server 2008

TITLE: Distributor Properties
------------------------------

Could not add distribution database ''distribution''.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1&EvtSrc=Microsoft.SqlServer.Management.UI.DistributorPropertiesErrorSR&EvtID=CantAddDistributionDB&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Could not add the distribution database ''distribution''. This distribution database already exists.
Changed database context to ''master''. (Microsoft SQL Server, Error: 14119)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600&EvtSrc=MSSQLServer&EvtID=14119&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------





签入系统数据库列表,它已经是分发名称中的数据库。
Hi ,

Check in system databases list , it already the database in the name of distribution.