SQL 2005 consistency-based I/O error

  • SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0x55555555; actual signature: 0x15555555). It occurred during a read of page (1:671644) in database ID 14 at offset 0x00000147f38000 in file 'E:\Database\ProductionRep_Data.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.

    I got this error while exec query

    if any face similar prob

    pls help us

  • Please don't cross post. It just wastes people's time and fragments replies.

    No replies to this thread please. Replies to: http://www.sqlservercentral.com/Forums/Topic812740-266-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply