Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Subscribers are no longer getting all update applied at th..

 
   Database Help (Home) -> Replication RSS
Next:  Oracle DB to MS Sql Server DB Replication questio..  
Author Message
jheaphy

External


Since: Aug 12, 2008
Posts: 3



(Msg. 1) Posted: Tue Aug 12, 2008 5:01 pm
Post subject: Subscribers are no longer getting all update applied at the Publisher
Archived from groups: microsoft>public>sqlserver>replication (more info?)

Some of the database updates on the Publisher are not being downloaded
to the Subscriber. However, all the changes at the subscribers are
being uploaded successfully to the Publisher. But, when I do a
complete download to a new local database I get all the data from the
Publisher. We've been running live for about one month. This was
working fine and we have made no configuration changes. I'm wondering
if we have the Publication configured correctly. And if we are might
some scheduled jobs.

 >> Stay informed about: Subscribers are no longer getting all update applied at th.. 
Back to top
Login to vote
Hilary Cotter3

External


Since: Aug 28, 2004
Posts: 441



(Msg. 2) Posted: Sat Aug 16, 2008 11:21 am
Post subject: Re: Subscribers are no longer getting all update applied at the Publisher [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Is it possible that these errors are showing up in the conflict table?

I also recently opened up a bug which involved timestamp columns which are
not at the end of a table.

Is this possibly your case too?

"jheaphy" <jjheaphy.RemoveThis@gmail.com> wrote in message
news:aa17b0ce-022e-4163-8af7-eb5dc96c3562@a2g2000prm.googlegroups.com...
> Some of the database updates on the Publisher are not being downloaded
> to the Subscriber. However, all the changes at the subscribers are
> being uploaded successfully to the Publisher. But, when I do a
> complete download to a new local database I get all the data from the
> Publisher. We've been running live for about one month. This was
> working fine and we have made no configuration changes. I'm wondering
> if we have the Publication configured correctly. And if we are might
> some scheduled jobs.

 >> Stay informed about: Subscribers are no longer getting all update applied at th.. 
Back to top
Login to vote
jheaphy

External


Since: Aug 12, 2008
Posts: 3



(Msg. 3) Posted: Sat Aug 16, 2008 12:50 pm
Post subject: Re: Subscribers are no longer getting all update applied at the [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On Aug 16, 8:21 am, "Hilary Cotter" <hilary.cot....TakeThisOut@gmail.com> wrote:
> Is it possible that these errors are showing up in the conflict table?
>
> I also recently opened up a bug which involved timestamp columns which are
> not at the end of a table.
>
> Is this possibly your case too?
>
> "jheaphy" <jjhea....TakeThisOut@gmail.com> wrote in message
>
> news:aa17b0ce-022e-4163-8af7-eb5dc96c3562@a2g2000prm.googlegroups.com...
>
> > Some of the database updates on the Publisher are not being downloaded
> > to the Subscriber. However, all the changes at the subscribers are
> > being uploaded successfully to the Publisher. But, when I do a
> > complete download to a new local database I get all the data from the
> > Publisher. We've been running live for about one month. This was
> > working fine and we have made no configuration changes. I'm wondering
> > if we have the Publication configured correctly. And if we are might
> > some scheduled jobs.

Nope, no conflicts. I wish! I've opened a support ticket with
Microsoft and will post the results.
 >> Stay informed about: Subscribers are no longer getting all update applied at th.. 
Back to top
Login to vote
jheaphy

External


Since: Aug 12, 2008
Posts: 3



(Msg. 4) Posted: Wed Aug 27, 2008 9:10 am
Post subject: Re: Subscribers are no longer getting all update applied at the [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On Aug 16, 12:50 pm, jheaphy <jjhea....DeleteThis@gmail.com> wrote:
> On Aug 16, 8:21 am, "Hilary Cotter" <hilary.cot....DeleteThis@gmail.com> wrote:
>
>
>
> > Is it possible that these errors are showing up in the conflict table?
>
> > I also recently opened up a bug which involved timestamp columns which are
> > not at the end of a table.
>
> > Is this possibly your case too?
>
> > "jheaphy" <jjhea....DeleteThis@gmail.com> wrote in message
>
> >news:aa17b0ce-022e-4163-8af7-eb5dc96c3562@a2g2000prm.googlegroups.com...
>
> > > Some of the database updates on the Publisher are not being downloaded
> > > to the Subscriber. However, all the changes at thesubscribersare
> > > being uploaded successfully to the Publisher. But, when I do a
> > > complete download to a new local database I get all the data from the
> > > Publisher. We've been running live for about one month. This was
> > > working fine and we have made no configuration changes. I'm wondering
> > > if we have the Publication configured correctly. And if we are might
> > > some scheduled jobs.
>
> Nope, no conflicts. I wish! I've opened a support ticket with
> Microsoft and will post the results.

The problem was on the IIS server. We had to apply SQL2005 SP2 to
upgrade the Sql Client Tools on the IIS server. Then we had to apply
the latest hot-fix bundle to the IIS server:
Yukon_SP2_CU6/09.00.3228.00
 >> Stay informed about: Subscribers are no longer getting all update applied at th.. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
SQL 2005: Manage Subscribers? - Hello! I'm in the process of migrating our replication server to 2005, and i'm a little perplexed as to where the subscriber management has gone. In EM 2000 you can right click on the Replication folder, choose "Configure Publishing, Subscribers ...

Duplicate entries in the Subscribers tab of Publisher Prop.. - In my SQL2000 replication sandbox, after removing replication via wizards, and adding it again, I have two ways to use wizards to add Subscribers. I can expand Replication|Publications node to show my publication (pubs:pubs) and right-click on that an...

Applied schema changes and merged 0 data change(s) (0 inse.. - Hello, We are using SQL Server 2005 merge replication, and have custom monitoring on all databases. We start getting follwoing alert for one of the merge publication. "Applied schema changes and merged 0 data change(s) (0 insert(s), 0 update(s)...

SQL Compact Merge replication no longer works after VS SP1.. - I have 2 separate machines that recently had a clean install. Both machines are Windows XP SP3 with Visual Studio 2008. I have a project that uses SQL Compact Merge replication to a backend SQL 2005 database; In each case after installing VS 2008 SP...

UPDATE ROWGUID - I have two table with the same data but rowguid are different. I have a conflict with violation of primary key. How can I align rowguid without delete row (they are in foreign key with other table) ?
   Database Help (Home) -> Replication All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]