Push Replication: Must I reinitialize the snapshot every time?

• bimplebean

  Say Hey Kid

  Points: 706

  More actions

  October 8, 2015 at 10:51 am

  #308779

  Quick question: I am push replicating a database from one 2012 server to another. It's snapshot replication. I have created the publication and initialized the snapshot; I have also created the subscription. Doing this in SSMS has created two jobs, one for each step. One job initializes the snapshot, the other does a push replication.

  I am copying steps from those jobs onto the end of a nightly maintenance job on the source server. The goal is to do the maintenance, then push replicate the updated database to the other server.

  Steps:

  1. Restore a database from a downloaded file

  2. Perform maintenance on that database and others

  3. Push Replicate those updated databases to another server

  Question: Do I need to include the 'initialize snapshot' step in the nightly job, i.e. every night, or do I only need the 'Push Replication' step?

  I've been trying to Google an answer to that specific question but cannot find it.

  Any help is very much appreciated...

  Barry