x

REPLICATION

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?
more ▼

asked Apr 17, 2012 at 05:58 AM in Default

chinna gravatar image

chinna
10 4 5 5

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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:

SQL Server instance
  |- DB
     |- Publication 1
     |      |-Subscription 1
     |      |-Subscription....
     |      |-Subscription 16
     |
     |- Publication....
     |- Publication 16

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.
more ▼

answered Apr 17, 2012 at 06:52 AM

WilliamD gravatar image

WilliamD
25.9k 17 19 41

Hi Willam,

thanks for your reply . still i am facing the same issue even after recreating the subscription from scratch.
Apr 17, 2012 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, 2012 at 11:54 AM chinna

The limitations have already been discussed in [your previous question][1].

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.

[1]: http://ask.sqlservercentral.com/questions/88509/replication-limitation.html
Apr 17, 2012 at 12:40 PM WilliamD
(comments are locked)
10|1200 characters needed characters left

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?
more ▼

answered Apr 18, 2012 at 08:51 PM

Blackhawk-17 gravatar image

Blackhawk-17
11.9k 28 31 36

Hi Greg

for each publication we are configuring 5 to 8 articles.
Apr 19, 2012 at 09:58 AM chinna
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x305

asked: Apr 17, 2012 at 05:58 AM

Seen: 568 times

Last Updated: May 17, 2013 at 02:06 AM