Torn Page error

• *Prashant Thakwani

  SSCommitted

  Points: 1827

  More actions

  May 3, 2004 at 11:35 pm

  #179632

  I am getting the following error message while attaching my DB in SQL Server 2000.

   "Error 823:I/O error ( torn page) detected during read at offset 0x000000000026000 in file 'C:\TestFile.MDF.'

   

  I basically, detach the DB from my server and copy that MDF and LDF to another server. Then I Format my first server. Now when i am going to attach my MDF and LDF to second server, it gives me the above error.

  Thanks in advance.

   

  Prashant Thakwanithakwani_prashant@yahoo.co.in

• happycat59

  One Orange Chip

  Points: 29389

  More actions

  May 4, 2004 at 1:29 am

  #505082

  Have a look at article "Error 823" in books on line. 

  Based on what this article says, it sounds like the error will most likely have been caused by a disk error. However, this error has corrupted the database and this corruption may not be repairable.