title: SQL server replication error: "The initial snapshot for publication 'XYZ' is not yet available"
body: <p>I am using sql server 2012, and i've set up a snapshot replication between two servers. The snapshot agent completed successfully, however the replication agent seems keep running forever and cannot stop.</p>
  
  <p>The action message from replication monitor is like:  </p>
  
  <blockquote>
    <p>Initializing<br>
    Applied Script 'ScriptX.pre'<br>
    ...<br>
    Bulk copied data into table 'tabA'<br>
    ...<br>
    Delivered snapshot from the 'replicaDataSubFolder' sub-folder in x milliseconds<br>
    <strong>The initial snapshot for publication 'XYZ' is not yet available.</strong></p>
  </blockquote>
  
  <p>And then the action message stuck at the last sentence and cannot stop.<br>
  Any thoughts?</p>