Missing Replicated Transactions (backup - restore)


I have a table that is replicated to a remote distributor and subscriber (pull subscription). All works fine.

  • I add two records (1,2) to the publisher - these are sent to the distributor
  • I backup the publisher
  • 2 more records (3,4) are added to the publisher - these are sent to the distributor
  • I delete the subscriber and restore the publisher database as the subscriber
  • I see two records (1,2) on the subscriber
  • The next two records (3,4) are never synchronized from the distributor
  • If i add more records to the publisher, they are delivered to the subscriber. 3 and 4 still don't arrive!

My question is, why are the records 3 and 4 never delivered? I thought this was the whole point of the Distribution database keeping transactions for 72 (default) hours - so they could be replayed?

Any help greatly appreciated!

more ▼

asked Mar 31, 2010 at 01:02 PM in Default

Dave 5 gravatar image

Dave 5
1 1 1 2

Just curious here, what happens if after deleting the subscriber more records are added at the publisher prior to the restore? Are they replicated or skipped?
Mar 31, 2010 at 02:14 PM Blackhawk-17
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
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



Answers and Comments

SQL Server Central

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



asked: Mar 31, 2010 at 01:02 PM

Seen: 955 times

Last Updated: Mar 31, 2010 at 03:23 PM