Snapshot replication for large database

  • Hi

    is snapshot replication is supported for large databases??? can anyone please help me out in this regard..

    as i am confused with the statements

    "Snapshot replication has a lower continuous overhead on the Publisher than transactional replication, because incremental changes are not tracked. However, if the dataset set being replicated is very large, it will require substantial resources to generate and apply the snapshot. Consider the size of the entire data set and the frequency of changes to the data when evaluating whether to utilize snapshot replication. "

    my database is of 20GB.

    :w00t:


    Thanks ,

    Shekhar

  • No issues. The statement only informs you that you will have stale data if there are very frequent changes :p. From where you got this statement by the way?

    -LK

  • As above the statement is just warning you about the size of the snapshots, if you snapshot a 20gb database then everytime you sync the data you are moving 20gb each time. By design transactional replication does at it says on the tin, it moves over the required transactions, so they are a lot smaller than the complete db. The use of both replication types though are very different and you need to use the one that works in your environment.

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

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