Timeline for Convert existing subscriber Database to a publisher database. Current publisher will be subscriber
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 3, 2017 at 15:58 | comment | added | SqlWorldWide | Did you try running 'sp_scriptpublicationcustomprocs'? | |
| May 3, 2017 at 13:24 | comment | added | engrmigs | i know i already marked this as answer but I recently encountered error in the latter part. the publisher to distributor have no issue, but on monitoring the distributor to subscriber is always on pending status. I always receive this message 'Procedure or function sp_MSreplraiserror has too many arguments specified. (Source: MSSQLServer, Error number: 8144 ) Get help: help/8144' I have checked and did the steps on the attached KB article, but nothing happened and I still receive the same error. Appreciate your feedback. | |
| May 2, 2017 at 7:33 | vote | accept | engrmigs | ||
| Apr 27, 2017 at 1:51 | comment | added | SqlWorldWide | Yes it is ok, I meant to add distribution database as remote distributor if this is on a separate instance(same host), if not (on the same instance) you can skip that step. | |
| Apr 27, 2017 at 1:50 | history | edited | SqlWorldWide | CC BY-SA 3.0 |
added 223 characters in body
|
| Apr 26, 2017 at 21:23 | comment | added | engrmigs | Thanks for a detailed answer. I have some clarifications though. The current setup is that the distributor db and subscriber db is in one sql server. The publisher is in different sql server. Now after i switch the publisher and the subscriber, the distributor db should remain and not switch server (in the new setup the publisher and distributor will now be in same sql server). This is because of the space limitation of the sever on the previous publisher. In your instruction the distributor is to be on the new publisher. Is it okay the dist db will remain on current server? | |
| Apr 25, 2017 at 12:16 | history | answered | SqlWorldWide | CC BY-SA 3.0 |