Post reply

Snapshot Replication

  • July 23, 2008 at 10:02 am

    #188482

    Hi,

    If i have scheduled a snapshot replication on daily basis, will be publisher will send the snapshot of the ENTIRE database daily or will it send the snapshot of the NEW data that arrive since the last snapshot?

    Thanks,

    Usman

  • July 23, 2008 at 10:13 am

    #847175

    Snapshot Agent will send all the tables, SP etc taken in Publication daily and override the existing data at Subscriber , So as per your Question snapshot will not send changes but all the data again .

    If you only wants shanges then Better go for Transactional Replication

    I hope i answer your question

  • July 23, 2008 at 10:18 am

    #847178

    thanks, but then in which cases snapshot is usefull........... i mean mostly databases are of very huge sizes and replication is mostly implemented with huge datases........so wats the benefit or when to use snapshot replication?

    Thnks

    Usman

  • July 23, 2008 at 10:23 am

    #847186

    Snapshot is useful when the Database is not big and you need some database or few tables in database for reporting perpose this is one of typical use of snapshot. But if you require live data at both Publisher and Subscriber then Snapsot is not a option .

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

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