sql server replication: Latency In Transactional Replication -- sql server replication

Latency In Transactional Replication

sqldba
10/19/2006 4:27:20 PM

sql server replication:

During last couple of weeks some new Tables & Fields were added. SO both the
time i have to re-intialize the Replication. my question is about LATENCY
where i have seen for both the subscriber(SUB) for SUB-1 is 3.5 Hours &
SUB-2 is 21 hrs. Size of the PUBLISHER DB is 18GB. AS Latency are in
Millisecs i have mentioned in HOURS for better understanding. i want to know
how i can resolve this issue as every time when new table or fields are
added it takes 21-22 hours to complete Replication Re-intialization process.

Re: Latency In Transactional Replication

myrights99 NO[at]SPAM gmail.com
10/24/2006 12:07:26 PM

TWO new Tables were added with unique key for couple of fields & were
not going to be use in Transactional Replication due to limitation that
each table needs to have at least one PK. and this 2 tables as no PK.
So using sp_repladdcolumn will not help, i maybe wrong.
please correct me if i am wrong as i am not SQL expert. again any help
& to correct me will be appreciated.

[quoted text, click to view]

Re: Latency In Transactional Replication

Paul Ibison
10/25/2006 12:00:00 AM

Now I'm confused :) - if you're adding tables to a publication this is
supported and adding columns to an already published article is supported,
but this seems to be not relevant to your case somehow. Is the problem that
you want to add tables which don't have a PK? This is definitely
unsupported, but you already know that, so please can you add a few more
details about what it is that you want to do.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Re: Latency In Transactional Replication

myrights99 NO[at]SPAM gmail.com
11/6/2006 7:24:35 PM

Dear Mr. Paul:
I have replied back with details & did see your
feedback. i will appreciate if you please kindly reply me at your
earliest & doing so will be highly appreciated.

thanks

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.