When setting up replication on an SQL-Server 2012 we accidentally set the name for the distribution-db to the name of one of our user-db's.The user-db had all the distribution objects in it and showed under "system databases" in ssms. After we realized this, we removed all replication and distribution on the server; our database showed outside system again, and we removed all distribution objects from it.We then proceeded to set up distribution again, this time using the name "distribution09" for our distribution-db. All went well - however when trying to set up replication on the mentioned user-db, it fails:"Meldung 208, Ebene 16, Status 1, Prozedur syssubscriptions, Zeile 1Ungültiger Objektname 'dbo.IHsubscriptions'."
It is possible to create the table 'IHsubscriptions' in our user-db; after that setting up replication will fail on the NEXT needed object. Therefore, it seems the server is still trying to use our user-db as the distribution-db.Using the following commands shows the correct 'distribution09' in all the right places as the current distribution-db:EXEC sp_get_distributorSELECT is_distributor FROM sys.servers WHERE name='repl_distributor' AND data_source=@@servername;SELECT name FROM sys.databases WHERE is_distributor = 1EXEC sp_helpdistributor;EXEC sp_helpdistributiondb;EXEC sp_helpdistpublisher;
Any idea, how this can be fixed? Thanks in advance,Dirk
Replication fails: User-DB had been Distr.-DB
Posted - 2014-03-14 : 10:07:23
