|
Hi, we have 3 publisher databases for each publisher db we have 2 subscription db's with 16 transactional publications in each publisher DB.now i added one more publisher DB with 2 subscription db's but I can not see the subscription on the subscription node and i can see this subscription on the Publisher's Server's Subscription node and replication triggers also not created.Can you please let me know the solution for this?
(comments are locked)
|
|
It looks like the creation didn't run through completely. I suggest recreating the subscription from scratch (drop the existing half-built subscription first). EDIT (After OP's comment): You have posted a lot of requests recently about replication, with slightly differing content. It seems that you are having quite a few issues with replication in general - in particular in this question you seem to be misusing some of the nomenclature for replication. If I understand you correctly, you have the following: You want to add a 17th Publication with 2 subscriptions. The publication is created fine, but the creation of the subscription is created without error, but no entry is appearing on the subscriber node. That to me sounds like you are creating the publication and subscription via scripts and are not running the subscription creation on the subscriber machine (a pull subscription where the distributor runs on the subscriber and not on the publisher). I suggest you re-try building the publication and subscription using the GUI tools to ensure each step is run correctly. Also ensure that the accounts used in replication have the required permissions on the subscriber machine. Hi Willam, thanks for your reply . still i am facing the same issue even after recreating the subscription from scratch.
Apr 17 '12 at 07:06 AM
chinna
Hi, thanks for your suggestions. yes we are using scripts but we have push subscriptions. is there any limitations for push subscriptions
Apr 17 '12 at 11:54 AM
chinna
The limitations have already been discussed in your previous question. I suggest not using your scripts (they are not working anyway), but using the GUI to get it working. You then have the option of saving the GUI settings as a script for future use.
Apr 17 '12 at 12:40 PM
WilliamD
(comments are locked)
|
|
As @William Durkin mentioned, check your accounts and permissions. Especially on any Distribution folders... and their disk space. How many Articles are you configuring per publication? Hi Greg for each publication we are configuring 5 to 8 articles.
Apr 19 '12 at 09:58 AM
chinna
(comments are locked)
|

