title: SQL Server detected a logical consistency-based I/O error.torn page It occurred during a read of page
body: <p>I get the underlying error when I run the following query. Can you please help?</p>
  
  <p>MY QUERY:</p>
  
  <pre><code>insert into MyDatabaseName.dbo.BoxContents (BoxContentID, Deleted, CreatedBy, CreatedDate, ModifiedBy, ModifiedDate, AuthCode, BoxID, ItemID, VariantAID, VariantBID, VariantCID, SerialNo, LotNo, Amount, Amount2, Amount3, SpecialCode, IntCode, Transferred, TransferDate, Locked, LockedBy, InOut)
  select BoxContentID, Deleted, CreatedBy, CreatedDate, ModifiedBy, ModifiedDate, AuthCode, BoxID, ItemID, VariantAID, VariantBID, VariantCID, SerialNo, LotNo, Amount, Amount2, Amount3, SpecialCode, IntCode, Transferred, TransferDate, Locked, LockedBy, InOut
  from MyDatabaseName2.dbo.BoxContents
  where not BoxContentID in (
          select BoxContentID
          from MyDatabaseName.dbo.BoxContents
          where CreatedDate &gt; dateadd(day, - 19, GETDATE())
          )
      and CreatedDate &gt; dateadd(day, - 19, GETDATE())
  </code></pre>
  
  <p>ERROR MESSAGE:</p>
  
  <blockquote>
    <p>SQL Server detected a logical consistency-based I/O error: torn page It occurred during a read of page (1:15856129) in database ID 9 at offset 0x00001e3e402000 in file 'H:\KLON_DATA**my database name.mdf'.  Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.</p>
  </blockquote>