Transactional replication

• Raghavender Chavva

  SSCrazy Eights

  Points: 8669

  More actions

  May 13, 2011 at 12:33 am

  #389519

  Hi All,

  Before setting up the transactional replication we have restored the publisher database to subscriber. So it can have most recent information.

  After this transactional replication setup was done. here do we need to run the snapshot job compulsary ?

  For every replication why we need to run snapshot job as a first step ?

  Thank You.

  Regards,
  Raghavender Chavva

• MysteryJimbo

  SSC-Insane

  Points: 24203

  More actions

  May 13, 2011 at 3:52 am

  #1324153

  You can set up a subscription with no snapshot requirement.

  When you script the subscription, change this

  @sync_type = N'automatic'

  to this

  @sync_type = N'none'

  and run this on the publication database to generate the replication stored procedures which you will need to apply on the subscription database.

  exec sp_scriptpublicationcustomprocs 'publication name'

  It is important to ensure nothing is being edited on the publication database from the point of backup.