错误:存在分发数据库,但系统数据库中没有此类数据库
创建分发数据库时出现此错误。我正在尝试在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.