Post reply

Snapshot Agent in Transactional Replication

  • June 10, 2010 at 2:40 pm

    #222638

    Hi,

    What does the snapshot agent do after the initial snapshot is taken in a transactional replication? If the snapshot agent is scheduled to run twice a day, does it just get the snapshot of the changes made to the schema or does it get the snapshot of all the articles published each time it runs? Explanation of how the snapshot agent works in this case will be greatly appreciated.

    Thanks,

    Beulah Kingsly

  • June 11, 2010 at 2:37 am

    #1179050

    It is same as the initial snapshot.

    Schema changes are replicated by transactional replication.

  • June 11, 2010 at 5:18 am

    #1179092

    Thanks Suresh. Will only the changes to schema be replicated or will the entire schema be copied over (as in initial snapshot)?

  • June 14, 2010 at 6:34 am

    #1179809

    Snapshot agent replicates entire schema (as in initial snapshot).

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

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