asked
Replication refers to old instance
I am trying to get replication configured on SQL 2008 and am getting a very random error. I had 2 SQL 2005 instances (A and B) that replicated (transactional) 2 databases (db1 and db2). I have done a side by side install of SQL 2008 (2 instances C and D) and transferred (backup/restore) the databases to SQL 2008 on instance C. I have replicated db1 to instance D with no errors or warnings. When I try to replicated any part of db2 I get and error saying: > The Publisher 'server\instanceA' does > not exist. To view a list of > Publishers, use the stored procedure > sp_helpdistpublisher. Changed database > context to 'db2'. (Microsoft SQL > Server, Error: 21618) this happens regardless of instance A being started or not. Does anyone have any suggestions on how this might be resolved? Creating a script from the replication GUI leads to a ms_repl_somethingorother that has the error but I cannot locate this procedure in any database, on any instance.
You only "moved" databases db1 and db2 from instance A to C? When you restored, did you include the KEEP_REPLICATION option (not default and not needed as far as I can see). Would it be possible for you to completely remove replication and start again? Not something I would do first off, but I have experienced replication to be a fragile system to say the least. Problems that I have had in the past, that have cost me days have ended up being "fixed" by starting afresh.
