title: Replication problem (distribution with subscriber) in SQL SERVER 2008 R2
body: <p>We have transactional replication between two MS SQL Server 2008 R2.</p>
  
  <p>Our servers were rebooted because of failure of a hard drive.<br>
  Replication automatically continued working. But in an hour after we received such error:  </p>
  
  <pre><code>   The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated.
  </code></pre>
  
  <p>Log Reader agent works and sends transactions to distributor.
  But distributor stopped being able to synchronize with subscriber.</p>
  
  <p>Also Subscriber allowed to send changes to distributor. All conflicts resolved by distributor.</p>
  
  <p>We want to know if it is another way to make replication works except of reinitializing subscription?</p>
  
  <p>We discovered that this error probably was not in disk failure.<br>
  We added new foreign keys:</p>
  
  <p>So it was:</p>
  
  <pre><code>Publisher  Table1 Table2 Table3
  Subscriber Table1 Table2 Table3
  </code></pre>
  
  <p><code>Table1</code> and <code>Table2</code> were in replication. <code>Table3</code>  - not.<br>
  We added foreign key <code>Table2_Table3</code> on each - Publisher and Subscriber.</p>
  
  <p>And after this we began to receive errors as we described in the our  comment to @Remus Rusanu answer.</p>