Replication Script with no initial snapshot

• Shark Energy

  SSCrazy Eights

  Points: 8389

  More actions

  September 24, 2007 at 12:21 pm

  #178061

  Hey all,

  I have scripted out replication, but running this means that it wants to sync with a data snapshot to begin. I never use this method, instead manually putting the repl custom procs in and the data is already sync'ed.

  What do I need to change in the script to do this? I thought it was the synctype parameter but didn't seem to be the case. My only way round it so far is to manually add the subscribers but I'm sure I'm just not looking hard enough!

  Cheers in advance!

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  September 25, 2007 at 5:34 am

  #735960

  You're right about the @sync_type parameter. A value of 'none' should indicate that the subscriber already has the schema and data is synchronised.

  What parameter value are you using?

  Markus

  [font="Verdana"]Markus Bohse[/font]