Post reply

Reapplying Original Snapshot

  • July 26, 2005 at 9:52 am

    #165434

    What is the process to reapply the original or first snapshot created in Transactional Replication ? Does reinitializing the subscriber do this or will a new snapshot have to be rgenerated ?

    Also, what is the process to reapply the previous commands stored in the dustribution database to the subscribers ?

    Thanks

  • July 27, 2005 at 2:22 am

    #577452

    Hi,

    If I remember correctly. If you reinitialize the subscriber, it will apply the next snapshot created by the snapshot agent (run at the publisher). This is basically ensuring that you have the same data and schema on Publisher and subscriber.

    Regards..Graeme

  • July 27, 2005 at 4:34 am

    #577489

    After reinitializing you must run the snapshot aqent or wait until it runs itself (once per week). Then you must run the snapshot agent or wait until it runs itself.

    --

    Hilary Cotter

    Looking for a SQL Server replication book?

    http://www.nwsu.com/0974973602.html

    Looking for a FAQ on Indexing Services/SQL FTS

    http://www.indexserverfaq.com

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

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