question

Dave 5 avatar image
Dave 5 asked

Missing Replicated Transactions (backup - restore)

Hi,

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!

sql-server-2008replication
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Blackhawk-17 avatar image Blackhawk-17 commented ·
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?
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.