Post reply

Under Transactional replication when trying to replicate a few tables out of the entire DB.

  • December 9, 2010 at 7:42 am

    #242382

    Under Transactional replication when trying to replicate a few tables out of the entire DB.

    Does the entire log get sent over or just part of the transaction log?

    Thanks

  • December 9, 2010 at 7:44 am

    #1260562

    You select the articles (tables) you want to replicate, and the data relevant to them gets sent over.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • December 9, 2010 at 7:59 pm

    #1260864

    The most common way to get new subscription to transactional replication publication is to use a snapshot of the articles (tables). The snapshot is a bulk copy of the "current" contents of the tables.

    The database log is not required for this part of transactional replication. It is used to get the details of each insert/update/delete transaction done after the snapshot was taken of the publishing database tables.

    Behind the scenes, replication stores information about the point in time that the snapshot was taken so that it knows when the records of the insert/update/delete transactions should be applied to the subscriber. This is stored in the distribution database.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply